Apr 14 2022 10:52 AM - edited Apr 14 2022 10:52 AM
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....
Apr 14 2022 11:26 AM
Solution=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.
Apr 14 2022 12:12 PM
Apr 14 2022 11:26 AM
Solution=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.