View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
girlieinsd girlieinsd is offline
external usenet poster
 
Posts: 1
Default How do I round up numbers when dividing?

What I am doing is in regards to money. I am dividing an amount between two
people and sometimes the amount can't be divided equally so I want to be able
to have the formula automatically adjust.

So for instance: $5000.23 divided by 2 does not divide equally.
So person A should get $2500.12
and person be should get $2500.13

The same thing goes for $523.00

Thanks.