Forum Discussion
Solved
IF Function
Good day! I was wondering if anyone knew how to do an IF function for the attached file. I am trying to get the amount in column D to be "950" if column B or C has a 1 in it. If B or C ha...
More exactly
=IF(OR(B2=1,C2=1),950,S2/(B2+C2))
( I think ) D2 : =IF(AND(B2=1,C2=1),950,S2/(B2+C2))
More exactly
=IF(OR(B2=1,C2=1),950,S2/(B2+C2))
Thank you very much! This worked perfectly!!
You are welcome
