Hi...
May i know what is wrong in this formula. I am getting result as "False" instead of Please look into it OR All well.
=IF(AND($P4="1 Phase",DO4=""),IF(AND($P4="2 Phase ",$DQ4=""),IF(AND($P4="3 Phase ",DS4=""),IF(AND($P4="4 Phase ",DU4=""),IF(AND($P4="5 Phase ",DW4=""),"Please look into it"),"All well")))).
here column DO,DQ,DS,DU,DW contains numbers.
Thanks,
Dee
May i know what is wrong in this formula. I am getting result as "False" instead of Please look into it OR All well.
=IF(AND($P4="1 Phase",DO4=""),IF(AND($P4="2 Phase ",$DQ4=""),IF(AND($P4="3 Phase ",DS4=""),IF(AND($P4="4 Phase ",DU4=""),IF(AND($P4="5 Phase ",DW4=""),"Please look into it"),"All well")))).
here column DO,DQ,DS,DU,DW contains numbers.
Thanks,
Dee