I need to have in one cell the price, the cell below it the percentage off, with the cell below it the price after the percentage off.

What is the formula that I write into the total cell to produce this?

Ex.

$100 <--1st cell Original Price
15% <--2nd cell % off
$85 <-- 3rd cell Total

 

=A1*(1-A2)

or =A1*(100-A2)


depending if the cell has the % sign or not.

 

awesome...thanks