Forum Discussion
Solved
IF FORMULA
Using an IF formula how would you say; if C55 is Y and if H55 equals 1 and if F18 is between 5001 and 10000 then multiply by 300, (if all that same info but) if F18 is between 10001 and 15000 then mu...
=IF(C55="N","",IF(AND(C55="Y",H55=1,F18>=5001,F18<=10000),F18*300,IF(AND(C55="Y",H55=1,F18>=10001,F18<=15000),F18*450)))Maybe with this formula.
=IF(C55="N","",IF(AND(C55="Y",H55=1,F18>=5001,F18<=10000),F18*300,IF(AND(C55="Y",H55=1,F18>=10001,F18<=15000),F18*450)))Maybe with this formula.
Thank you sooooo much! I didn't know where to start. It works perfect!