Value greater than zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to set up a spreadsheet to show commissions earned. The formula would be =E12*.8 however, if the net sales is equal to a negative amount then there should be no commissions earned. So I would like the field to show 0.00 not a negative number such as (7,929). How can I achieve this in Excel? I tried to do it with conditional format but failed. Can someone please help me? Thank you in advance.
 
Hi

try

=IF(E12>0,E12*.8,0)

if i was you i would put the commission amount in another cell (say D1 or
whatever) and reference it, then you can change the commission value easily
without having to check all the formulas on the sheet. Doing this would
make the above formula:

=IF(E12>0,E12*$D$1,0)

the $ allow for the formula to be copied or filled without changing the
reference.

Cheers
JulieD

E Stephenson said:
I'm trying to set up a spreadsheet to show commissions earned. The
Click to expand...
formula would be =E12*.8 however, if the net sales is equal to a negative
amount then there should be no commissions earned. So I would like the
field to show 0.00 not a negative number such as (7,929). How can I achieve
this in Excel? I tried to do it with conditional format but failed. Can
someone please help me? Thank you in advance.
 
=MAX(YourFormula,0)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

E Stephenson said:
I'm trying to set up a spreadsheet to show commissions earned. The
Click to expand...
formula would be =E12*.8 however, if the net sales is equal to a negative
amount then there should be no commissions earned. So I would like the
field to show 0.00 not a negative number such as (7,929). How can I achieve
this in Excel? I tried to do it with conditional format but failed. Can
someone please help me? Thank you in advance.
 
Back
Top