| How to nest several IF functions. This one returns differing values where the value of A1 matches various criteria |
| IF_NESTED_1 =IF(A1<250,A1*0.1,IF(AND(A1>250,A1<=500),(25+(A1-250)*0.07),IF(AND(A1>500,A1<=1000),(25+17.5+(A1-500)*0.05),IF(AND(A1>1000,A1<=2000 ),(25+17.5+25+((A1-1000)*0.03)),(25+17.5+25+30+((A1-2000)*0.02))))))*1000 |