Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

I need help with an Excell formula I cannot figure out.

  1. Apr 21, 2013 #1
    Im trying to set up a spread sheet for my chef but Im 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 cant figure out how to make a formula work for this. IF anyone could help Id greatly appreciate it. Im not very good with excell, I can set up very basic formulas but this one has me stuck. Thank you in advance.
  2. jcsd
  3. Apr 21, 2013 #2


    User Avatar
    Gold Member


    =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.
  4. Apr 21, 2013 #3
    Wow, Thanks! I was looking around in the formulas to see if I could find something. Thanks for the help!
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook