Forum Discussion
Lengthy If And Formula
Hi All, I'm looking for a way to simplify the IF And formula below. I believe there should be an easier way to do this without writing numerous IF And statements in one line. You will note the formu...
Hi Hans, thank you so much for your reply. I took the formula you provided and modified it as follows:
=MAX(5*QUOTIENT(B3-2699,100)+35,0)
In the above, anything up to 1999 does not add anything. 2000 adds 5, 2100 adds 10 etc. which is exactly what we need.
The only thing I have not figured out is what the 35 represents. Would you mind explaining?
Thanks again for all your help.
35 is the amount you start with when the amount is 2000.