Blank cell vs. cell with a 0 numerical value

[dunmore83]

Hi,

I need the following formula to treat a cell with a blank value compared to a cell with a 0 numerical value differently;

=IF($G226>TODAY(),"",IF($AT226=0,0,IF($AT226="",BC225,(AT226/$CG226))))

However it is treating AT226 the same whether it has a 0 value or whether it is blank.

Any ideas how to resolve this issue?

Thanks

 

[Oeldere]

Bc225 = 0 ?

 

[gaz_chops]

Try

=IF($G226>TODAY(),"",IF(and($AT226<>"",$AT226=0),0,IF($AT226="",BC225,(AT226/$CG226))))

 

[dunmore83]

Thankyou gaz chops!! That works.

 

[gaz_chops]

You're welcome.