NEGATIVE PERCENT FORMULA
 

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 =)

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 =)

NEGATIVE PERCENT FORMULA
 

Tammy, It depends on how you have the percentage in F18.

If it shows as -60%
=F17 + (F17 * F18)
if F18 just shows .6 or 60% then
=F17 - (F17 * 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 =)

NEGATIVE PERCENT FORMULA
 

=F17*40%

--


Regards,


Peo Sjoblom


"Tammy V." <Tammy wrote in message
...
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 =)