Need help with IF command
 

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?

Need help with IF command
 

Try this

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

Mike

"Tobias" wrote:

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?

Need help with IF command
 

another

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

Mike

"Tobias" wrote:

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?

Need help with IF command
 

And yet another: =(B3=8)*(C3=8)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Tobias" wrote in message
...
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?