I want to have a nested IF with two conditions
 

IF (H6B6 AND I6c6, then put 1, else put 0)

Try this:

=If(And(H6B6,I6C6),1,0)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mahendra" wrote in message
...
IF (H6B6 AND I6c6, then put 1, else put 0)

Try...

=IF((H6B6)*(I6C6),1,0)

Hope this helps!

In article ,
"Mahendra" wrote:

IF (H6B6 AND I6c6, then put 1, else put 0)