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 multiply by 450 and place the total in K55
Also I need to makes sure if C55=N then K55 stays blank
So over my head here....
=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.
2 Replies
=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!
