I with an Excell formula I cannot figure out.

[tkav1980]

Im trying to set up a spread sheet for my chef but I am stuck.

Cell B2 = invoice total
Cell C2 = chemical total
Cell D2 = Sum(B2-C2)
Cell E2 needs to be...if cell d2 < 4000 then multiply by 1%, if 4000 or greater multiply by 2%.

Im very stuck on E2 and can't figure out how to make a formula work for this. IF anyone could help Id greatly appreciate it. I am not very good with excell, I can set up very basic formulas but this one has me stuck. Thank you in advance.

 

[harborsparrow]

=IF(D2<4000,D2*0.01,D2*0.02)

=IF ( D2<4000 , D2*0.01 , D2*0.02 ) <-- with spaces added for readability

BTW, the Excel interface generated this for me; I just clicked on the Formulas page, clicked on Logical to indicate that I wanted logic functions such as "IF", and a popup window asked me for the arguments. I supplied the arguments, and it generated the text that got written into the cell.

 

[tkav1980]

Wow, Thanks! I was looking around in the formulas to see if I could find something. Thanks for the help!