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

Need IF AND Formula

Dear Team

Kindly Refer the attachment

I want put the formula in cell K2

Please find below condition & I need IF AND Formula

TO Nov'14 UAO Nov '14 Slab
<8
>5 1 Phase
>8
>3 2 Phase
>8
0-3 3 Phase

Thanks in advance

Regards
Basavaraj K H
 
Hi:

I have applied the following formula
=IF(AND([@[TO Nov''14 ]]<8,G2>5),$Q$3,IF(AND([@[TO Nov''14 ]]>8,[@[UAO Nov ''14 ]]>3),$Q$4,IF(AND([@[TO Nov''14 ]]>8,[@[UAO Nov ''14 ]]>-3),$Q$5,"")))

not sure is this what you are looking for, and also I am not sure about your last condition >8 0-3 3 Phase

Thanks
 
Back
Top