if or not if ???
 

hello all !!
i write just to ask if this...

=IF(A1=5;TRUE;FALSE)

is the same to this....

=(A1=5)

and the if function is useful just if i need result
different from true / false

tx !
paolo ita

if or not if ???
 

Hi,

If all you want to do is return TRUE/FALSE then =A1=5 is sufficient.

If you want a number you can use

=--(A1=5)

Which will return 1 or 0

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"pls123" wrote:

hello all !!
i write just to ask if this...

=IF(A1=5;TRUE;FALSE)

is the same to this....

=(A1=5)

and the if function is useful just if i need result
different from true / false

tx !
paolo ita

if or not if ???
 

<<<<<<<<
ty mike !
<<<<<<<<




"Mike H" wrote:


Hi,

If all you want to do is return TRUE/FALSE then =A1=5 is sufficient.

If you want a number you can use

=--(A1=5)

Which will return 1 or 0

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"pls123" wrote:

hello all !!
i write just to ask if this...

=IF(A1=5;TRUE;FALSE)

is the same to this....

=(A1=5)

and the if function is useful just if i need result
different from true / false

tx !
paolo ita