Need help with IF command

[Tobias]

Hi!

I would like to do something like:

IF(B3>=8 and C3>=8;1;0)

if (B3 is equal or bigger than 8 and c3 is equal and bigger than 8) this is
true give me 1 otherwise 0. How do I write that?

 

[Mike H]

Try this

=IF(AND(B3>=8,C3>=8),1,0)

Mike

 

[Mike H]

another

=AND(B3>=8,C3>=8)+0

Mike

 

[Bernard Liengme]

And yet another: =(B3>=8)*(C3>=8)
best wishes