simple formula

[Firecop1348]

this is so easy its stupid that I have to post here but for some reason I cant get it to work.

=IF(SUM(F37)>0,SUM((F37*F38)+F37),"")

the above adds a % to the total, I need cell F38 SUBTRACTED from cell F37 for my total amount in cell F39
Thanks

 

[barry houdini]

Try

=IF(F37>0,(1-F38)*F37,"")

 

[Firecop1348]

Nope that turned a $50.00 sub total into a Exact the way it looks in cell (1200.00) with ( ) around total. after putting 25.00 in cell 38

 

[Firecop1348]

Cell F 37 is a subtotal from Cells F 18 - F36, Cell 38 is supposed to be a amount of discount and the total is supposed to be in cell F39.
So if Cell 37 is $50.00 and I put $25.00 in cell 38 Cell 39 should show $25.00
But it wont work.

 

[barry houdini]

OK, I thought F38 was showing the % discount, if it just shows the discount as a dollar amount then try

=IF(F37>0,F37-F38,"")

 

[gsistek]

How about
=if(F37>0,F37-F38,"")

 

[MrKowz]

Edit - nevermind

 

[JackDanIce]

Try:

=IF(F37>0,F37-F38,"")

 

[Firecop1348]

Thanks that worked. I dont know what I was doing wrong but ill be a pro like you all in ohhhh about 10 years. LOL Thanks again.

 

[number kruncher]

If your grossing up F37 by the % in F38, then try..

=IF(F37>0,F37*(1+F38),"")