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.