I'm not sure how to use the "OR" function. I want to do the following:
IF A1 or A2 = "x" then B1*B2, if not then C1*C2
Do you guys have an answer. It's always easier than I think
Phoenix
I'm not sure how to use the "OR" function. I want to do the following:
IF A1 or A2 = "x" then B1*B2, if not then C1*C2
Do you guys have an answer. It's always easier than I think
Phoenix
Try...
=IF(OR(A1="x",A2="x"),B1*B2,C1*C2)
Hope this helps!
Looks good Thanx
Phoenix
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks