Can anyone answer this question?

  • Thread starter Thread starter Frustrated
  • Start date Start date
F

Frustrated

I am trying to find out if I can create a IF statement that will send out a
email if the IF statement is true or false, but not both?
 
It would be an interesting IF statement that returned both TRUE and FALSE :)

Well, you could due that with an array formula:

=IF(1=1,{TRUE,FALSE})

What practical use this might have is beyond me, however. :-)

--ron
 
Yes,

LOL, but as you say 'what practical value'

Next test, can you make it display false and this doesn't count.

=IF(1=1,{FALSE,TRUE})

Mike
 
Yes,

LOL, but as you say 'what practical value'

Next test, can you make it display false and this doesn't count.

=IF(1=1,{FALSE,TRUE})

Mike

Sure, just enter it as a 2-cell horizontal array. The first cell will display
TRUE, and the second cell FALSE
--ron
 
Back
Top