ExcelBanter - How do I create a formula that could have two different outcomes?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I create a formula that could have two different outcomes? (https://www.excelbanter.com/excel-worksheet-functions/6063-how-do-i-create-formula-could-have-two-different-outcomes.html)

Matt

How do I create a formula that could have two different outcomes?

duane

have you tired the "if" function? =if(expression, result 1, result2)

result 1 if expression is true, else result 2

--
duane

------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=276820

Frank Kabel

Hi
do you ment the IF function?

--
Regards
Frank Kabel
Frankfurt, Germany

"Matt" schrieb im Newsbeitrag
...

tjtjjtjt

Use the IF Function.
Check out the help files. Search for IF.

tj

"Matt" wrote:

All times are GMT +1. The time now is 11:15 PM.