SOLVED

IF FORMULA

Contributor

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....

 

2 Replies
best response confirmed by erin-5304 (Contributor)
Solution

@erin-5304 

=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!