Can anyone answer this question?

[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?

 

[Mike H]

Hi,

It would be an interesting IF statement that returned both TRUE and FALSE

The answer is no or not directly, you can't call a macro to send mail like
that. You would have to test the result of the IF statement using (say) the
worksheet calculate event and send the mail depending on the outcome.

have a look here for using mail

http://www.microsoft.com/office/com...ming&mid=e2665eda-6688-4b30-bcce-16018026b309

Mike

 

[ryguy7272]

Here you go:
http://www.rondebruin.nl/mail/change.htm

 

[Ron Rosenfeld]

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

 

[Mike H]

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

 

[Ron Rosenfeld]

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