• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Error correction in this formula

Dee

Member
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
 
Hi Dee,


Try this:


=IF(OR(AND($P4="1 Phase",DO4=""),AND($P4="2 Phase ",$DQ4=""),AND($P4="3 Phase ",DS4=""),AND($P4="4 Phase ",DU4=""),AND($P4="5 Phase ",DW4="")),"Please look into it","All well").


Regards,

Radu
 
Back
Top