- Joined
- Oct 10, 2007
- Messages
- 3,974
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.
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.