ppleasebob
Board Regular
- Joined
- Dec 23, 2002
- Messages
- 145
Started to look through the archive for an answer but there's just too many in there..
=IF('Enter Details here'!$A2="y",IF('Enter Details here'!$AC2>0,IF('Enter Details here'!$E2="PL",'Enter Details here'!B2," ")," ")," ")
It works with this, but I want it to return the value of B2 if E2 equals "PL" or "XSPL"
Would and 'OR' function work, if so, where would it go?
Thanks for looking..
=IF('Enter Details here'!$A2="y",IF('Enter Details here'!$AC2>0,IF('Enter Details here'!$E2="PL",'Enter Details here'!B2," ")," ")," ")
It works with this, but I want it to return the value of B2 if E2 equals "PL" or "XSPL"
Would and 'OR' function work, if so, where would it go?
Thanks for looking..