Is is null problem

[hotherps]

What I'm trying to say here is if DX11 is null, use the value from
B11

If DY11 is null then use the value from C11

else (meaning both DX11 and DY11 are not null)

continue on with the code


=IF(DX11="",B11,IF(DY11="",C11,IF(AND(G$9>=$DX11,G$9<$DY11),$DZ11)))

Thank

 

[JE McGimpsey]

What problem are you having? Your formula will do what you say you want.

 

[hotherps]

I may have changed it slightly, let me paste it again.

=IF($DX11="",$B11,IF($DY11="",$C11,IF(AND(G$9>=$DX11,G$9<$DY11),$DZ11,"")))


If I remove the value fromDX11 or DY11 the cells that the formula is i
have 0.354 ?

 

[JE McGimpsey]

You need to tell us why that's not correct. What do you expect to happen?
What are the values in B11, C11, DZ11?