IF ..

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..
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
Try this:

Code:
=IF(AND('Enter Details here'!$A2="y",'Enter Details here'!$AC2>0,OR('Enter Details here'!$E2="PL",'Enter Details here'!$E2="XSPL")),'Enter Details here'!$B2,"")
 

ppleasebob

Board Regular
Joined
Dec 23, 2002
Messages
145
Thanks, it's just what I needed, I now have a 4th function to add to my arsenal ..

Good weekend
 

ppleasebob

Board Regular
Joined
Dec 23, 2002
Messages
145
if .. part II

Kristy kindly got me going on this but need a bit more help now,

Users will populate various cells on a sheet say, a2, b2, c2, I want to use the value of the whichever single cell that has a value in it on a summary sheet.

Appreciate your assistance..

Regards

bob
 

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686

ADVERTISEMENT

Are you wanting to add this onto the current formula, or is this a separate issue?
 

ppleasebob

Board Regular
Joined
Dec 23, 2002
Messages
145
Kristy,

It is part of the same formula, I have used the formula in to return values in cells other than b2 (in the example above) and now I want to show the cell that has "PL" or "XSPL"
 

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,501
Members
412,670
Latest member
Khin Zaw Htwe
Top