rounding currency up with 2 decimal places

Giganews Newsgroups
Subject: rounding currency up with 2 decimal places
Posted by:  LindaB
Date: Tue, 28 Oct 2003

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.

Replies