IF ..

[ppleasebob]

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

 

[Von Pookie]

Try this:

=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]

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

Good weekend

 

[ppleasebob]

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]

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

 

[Pekkavee]

Maybe CONCATENATE formula.

Pekka

 

[ppleasebob]

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"