Im trying to set up a spread sheet for my chef but Im stuck.(adsbygoogle = window.adsbygoogle || []).push({});

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.

**Physics Forums | Science Articles, Homework Help, Discussion**

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.

Loading...

**Physics Forums | Science Articles, Homework Help, Discussion**