Excel: Nested If Statements

[maccten2000]

Hi All,

I have an excel worksheet that i want to colour code cells based on the values in them.

So lets take cells A1 & B1 as examples. Effectively what i want to say is

If value in A1 is 0
AND the value in B1 contains a value
AND this value is a number
Conditional Format it Yellow

Can anyone help me out. Its the Third instance of the and that has me slightly confused

Cheers

 

[SkipVought]

Hi,
[tt]
If value in A1 is 0
AND B1 contains a NUMBER

Formula is: =AND($A1=0,ISNUMBER($B1))
[/tt]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[maccten2000]

Hi Skip,


Thanks for the prompt reply. However it is possible for A1 to have a value other than a number which is why i need to get the three conditions into the nested If statement

If i wasnt using conditional formating The formula would be something like below.

=IF(AND(isnumber(A2)>0,AND(B2=0,A2>0)), "Yes", "No")

Cheers

 

[SkipVought]

If value in A1 is 0
AND the value in B1 contains a value
AND this value is a number

However it is possible for A1 to have a value other than a number which is why i need to get the three conditions into the nested If statement

That's NOT what you originally asked!

Please state your requirement, CLEARLY, CONCISELY and COMPLETELY!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[maccten2000]

Yup, Terribly sorry about that, It only came up after an additional request

 

[SkipVought]

Just drop the IF statement.

Use the expression instead.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}