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
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