I want to have a nested IF with two conditions

IF (H6>B6 AND I6>c6, then put 1, else put 0)

Try...

=IF((H6>B6)*(I6>C6),1,0)

Hope this helps!

In article <[email protected]>,
"Mahendra" <[email protected]> wrote:

> IF (H6>B6 AND I6>c6, then put 1, else put 0)

Try this:

=If(And(H6>B6,I6>C6),1,0)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mahendra" <[email protected]> wrote in message
news:[email protected]...
> IF (H6>B6 AND I6>c6, then put 1, else put 0)