Thread: Excel formulae
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anna Anna is offline
external usenet poster
 
Posts: 132
Default Excel formulae

I need to work out discount rate from price
Example
50 divided by 1.1 gives me the correct result 45
But if I divide 150 by 1.2 instead of giving me 120 the result is 125
I need one formulae I dont want work out first the discount rate and then
price - discount