View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
James James is offline
external usenet poster
 
Posts: 542
Default I have a problem with a formulae.

i am trying to make a formulae to show the cost of a certain cell.
One cell gets it's figure by calculating a percentage to reurn a value. Eg
54% of 30000 is 13,637. When i try to * this cell by an amount it sometimes
returns 3 or 4 pound more than what it should be. I have tried to set the
cells to no decimal places but i's not making a difference.

Help would be greatly appreciated.