lets say i have =ROUND(B7*(1+$B$17),0)
this returns to a cell $8022.00, i need it to return $8022 using just the ROUND function, no accounting style or some such. this is homeworrk that gets uploaded to an autograder which is really picky on how things get done, so if i use a style instead of the formula, ill get marked that part wrong.
anyone care to point me in the right direction? i assume i just have something wrong in the formula
fwiw
B7 contains "7428"
B17 contains "8%"
this returns to a cell $8022.00, i need it to return $8022 using just the ROUND function, no accounting style or some such. this is homeworrk that gets uploaded to an autograder which is really picky on how things get done, so if i use a style instead of the formula, ill get marked that part wrong.
anyone care to point me in the right direction? i assume i just have something wrong in the formula
fwiw
B7 contains "7428"
B17 contains "8%"
Facebook
Twitter