# IF ..

##### Board Regular
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..

### 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
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,"")``

##### Board Regular
Thanks, it's just what I needed, I now have a 4th function to add to my arsenal ..

Good weekend

##### Board Regular
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.

Regards

bob

#### Von Pookie

##### MrExcel MVP

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

#### Pekkavee

##### Well-known Member
Maybe CONCATENATE formula.

Pekka

##### Board Regular
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"

Replies
11
Views
251
Replies
1
Views
54
Replies
3
Views
36
Replies
2
Views
158
Replies
1
Views
158