NEGATIVE PERCENT FORMULA
Hi,
I assume you entered 60 in cell F18
=F17*(1+F18/100)
if you have entered 0.60 in cell F18 use
=F17*(1+F18)
"Tammy V." wrote:
I am creating a spread sheet, for sales. If the amount is $1838 and I need to
discount 60% what formula do I use?
example:
Cell F17 Total $1838
Cell F18 DISCOUNT -60%
Cell F19 Total after discount ??? Please help
Beginner =)
|