Hi dmmatic,

16101.35*1.3=20931.75
and
16101.35/0.7=23001.93
so the problem is with your checking.

If you use a formula like =(B1-A1)/A1, that will give you 0.3 (or 30%) for the first calculation, and 0.42857... (or 42.857%) for
the second calculation. The reason you don't get 0.7 or 0.3 for the second calculation is that dividing by 0.7 is equivalent to
multiplying by 1/0.7=1.42857... If you need 0.3 for the second calculation, you could use =-(A1-B1)/B1. Or you could use
=1+(A1-B1)/B1 to get 0.7.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

wrote in message ...
Can someone please explain me what is correct formula i excel.....I
need to markup or increase A1 for 30%

A1=16101.35
=A1*1.3 and that is 20931.75 (B1)
when I go to check =1-(A1/B1) i get 23%

--------------------------------------------------------

A1=16101.35
=A1/0.7 and that is 23001.93 (B1)
when I go to check =1-(A1/B1) i get 30%

So what is correct?