|Subject:||rounding currency up with 2 decimal places|
|Date:||Tue, 28 Oct 2003|
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.