You'd better look at your cell contents and your formula again if you think
that =A1*B1 gives 261900.00% in that situation. It should give 5.998 (or
599.8% if you format the cell as percentage). [Also check that Tools/
Options/ Calculation is set to automatic, not manual.]

If you have 20% in B1 and you want to add 20% to A1, your formula will be
=A1*(1+B1). [Formatting as currency will hopefully give you the answer in
dollars, if your settings recognise dollars as your default currency.]
--
David Biddulph

"Moe" wrote in message
...

(example A1 is $29.99 B1 is 20%)
When i use the formula =A1*B1 i get 261900.00%
i want to add 20 percent on A1 and get it in dollars
is there a formula for that

Thank you Again