If function and blank returns

**Stanstan** · 11-01-2011, 05:12 AM

Hi
I am trying to work out this problem with a function.

if a cell AA2 has data in it the function should return the data the A2 has in it. If AA2 is blank the whole line should be ignored.
If cell AA2 has data in it return the value of A2.
If Cell AA2 has value but cell A2 is blank return a value of 999

What I have so far,
=IF(Results!AA2=0,"",Results!A7)

That works but I'm really stuck on the rest.

S

**Domski** · 11-01-2011, 05:26 AM

So where does A7 come into it?

Dom

**Fotis1991** · 11-01-2011, 05:44 AM

ΗΙ

What I have so far,
=IF(Results!AA2=0,"",Results!A7)

Ι guess you mean Α2, because the description, you do not mention anywhere the cell A7

In this case, try this code.

Please Login or Register  to view this content.

Regards

**Stanstan** · 11-01-2011, 07:08 AM

Originally Posted by Fotis1991

ΗΙ

Ι guess you mean Α2, because the description, you do not mention anywhere the cell A7

In this case, try this code.

Please Login or Register  to view this content.

Regards

Hi

Thanks for the reply
Having done a bit more work on this I came up with
=IF(Results!AM11<>0,IF(ISBLANK(Results!M11)=TRUE,"992",Results!M11))
That is the actual code of course.

It is almost there other than it returns false when a cell in AM is blank

**Domski** · 11-01-2011, 07:43 AM

Please don't quote whole posts when replying to people.

Dom

**Fotis1991** · 11-01-2011, 08:26 AM

Hi.

Apart from the correct rating of Dom, once again giving us other numbers of cells(AM11 & M11).

IF(Results!AM11<>0,IF(ISBLANK(Results!M11)=TRUE,"992",Results!M11)

I at least get confused. I and other friends.

Sorry.

**Stanstan** · 11-01-2011, 02:16 PM

Hi

This function works now
=IF(Results!AM11<>0,IF(ISBLANK(Results!M11)=TRUE,"992",Results!M11)),"")

I hope it helps someone else.

Sorry about the reply using full quotes [gulp]

S