Adding a third variable to an IF statement

[Groovicles]

Hi everyone,

I have the following formula:

=IF(OR(ISNUMBER(FIND("M",'CORE Data Quarter'!B19)),ISNUMBER(FIND("L",'CORE Data Quarter'!B19))),'CORE Data Quarter'!A19,"")

What I'm trying to do is add another variable which states if 'CORE Data Quarter'!H19=blank, then 'CORE Data Quarter'!A19,""

On the flip side, if using the same formula as above, if "CORE Data Quarter'!H19 does not equal blank, then 'CORE Data Quarter'A19,""

I've tried:

=IF(AND('CORE Data Quarter'!H19=""),IF(OR(ISNUMBER(FIND("M",'CORE Data Quarter'!B19)),ISNUMBER(FIND("L",'CORE Data Quarter'!B19))),'CORE Data Quarter'!A19,""))

but i get FALSE for all results.

Any ideas?

[FDibbins]

=IF(OR('CORE Data Quarter'!H19="",ISNUMBER(FIND("M",'CORE Data Quarter'!B19)),ISNUMBER(FIND("L",'CORE Data Quarter'!B19))),'CORE Data Quarter'!A19,"")

Although your "flip-side" contradicts your new requirement?
if 'CORE Data Quarter'!H19=blank, then 'CORE Data Quarter'!A19,""
if "CORE Data Quarter'!H19 does not equal blank, then 'CORE Data Quarter'A19,""

And I presume you mean if the condition is met, use A19, otherwise use ""?

Edit: It might be better if you use SEARCH here instead of FIND - FIND is case-sensitive, so "Man" would be true, but "amount" would not

[Norie]

Have I misread?

If the cell is blank return the value in the cell.

If the cell isn't blank return the value in the cell.

[Groovicles]

Hi everyone,

Sorry, I didn't explain clearly. The "flip side" argument is for a different sheet that had other pre-existing criteria. In any case I think I've figured it out. Thanks for the responses everyone!