- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- rounding currency up with 2 decimal places

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.

- RE: rounding currency up with 2 decimal places posted by Jeff H on Tue, 28 Oct 2003
- Re: rounding currency up with 2 decimal places posted by J.E. McGimpsey on Tue, 28 Oct 2003