Hey all,
I'm writing a simple if statement and cannot figure out the proper syntax. Here's what I'm trying to say:
If (A1=1) AND (B1= 1 or 2 or 3 or 4), then insert a 1.
How do I incorporate the ors inside the and?
Hey all,
I'm writing a simple if statement and cannot figure out the proper syntax. Here's what I'm trying to say:
If (A1=1) AND (B1= 1 or 2 or 3 or 4), then insert a 1.
How do I incorporate the ors inside the and?
=and(a1=1,or(b1=1,b1=2,b1=3,b1=4))
or (if B1 is limited to integers)
=and(a1=1,b1>0,b1<5)
CC
If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks