Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|