rounding currency up with 2 decimal places

[Guest]

Hi:

I know this should be simple, but I can't figure it out. I have the following formula in a cell: =D6*1.16/0.8. It takes the value from cell D6multiplies it by 1.16 and then divides by .80. I would like to round the number up to the nearest whole number and have two zero decimal places. example: round number $78,118.75 to $78,119.00. I can get it to round up without the 2 decimal place, but not with.

Any help would be appreciated.

 

[J.E. McGimpsey]

one way:

=CEILING(D6*1.16/0.8, 1)

or

=ROUNDUP(D6*1.45, 0)

set your formatting to 2 decimal places.

 

[Guest]

try this =ROUND(+D6*1.16/0.8,0)