ssblue
asked on
Excel with two IF statements
I need the following to work, please.
IF D5 = 'C' and IF AI5 = '>0' then SUM(F5:AB5,AD5:AE5) otherwise put N/A
IF D5 = 'C' and IF AI5 = '>0' then SUM(F5:AB5,AD5:AE5) otherwise put N/A
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Do you mean if D5 = 'C' or D5 > 0?
=IF(OR(D5="C", D5>0), SUM(F5:AB5, AD5:AE5), NA())