| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statements...I think
I would like to create an IF statement such that IF A1 is not equal to nil or A2 is not equal to nil then A3 will display an X. In case this is not clear I have listed a couple of examples below: Example 1 A1="" A2="" therefore A3="" Example 2 A1=5.5 A2="" therefore A3=X Example 3 A1="" A2=Kevin therefore A3=X Example 4 A1=5.5 A2=Kevin therefore A3=X Thank you in advance. Kevin Knight -- kevinknight09 ------------------------------------------------------------------------ kevinknight09's Profile: http://www.excelforum.com/member.php...o&userid=37024 View this thread: http://www.excelforum.com/showthread...hreadid=567602 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statements...I think
=IF(OR(A1="",A2=""),"X","")
or if you want to display an error message, =IF(OR(A1="",A2=""),"X","You're error messgage, formula or whatever") Regards, Alan. "kevinknight09" wrote in message news:kevinknight09.2bxh0t_1154547628.2666@excelfor um-nospam.com... I would like to create an IF statement such that IF A1 is not equal to nil or A2 is not equal to nil then A3 will display an X. In case this is not clear I have listed a couple of examples below: Example 1 A1="" A2="" therefore A3="" Example 2 A1=5.5 A2="" therefore A3=X Example 3 A1="" A2=Kevin therefore A3=X Example 4 A1=5.5 A2=Kevin therefore A3=X Thank you in advance. Kevin Knight -- kevinknight09 ------------------------------------------------------------------------ kevinknight09's Profile: http://www.excelforum.com/member.php...o&userid=37024 View this thread: http://www.excelforum.com/showthread...hreadid=567602 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statements...I think
IF(AND(A1="",A2=""),"","X")
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "kevinknight09" wrote in message news:kevinknight09.2bxh0t_1154547628.2666@excelfor um-nospam.com... I would like to create an IF statement such that IF A1 is not equal to nil or A2 is not equal to nil then A3 will display an X. In case this is not clear I have listed a couple of examples below: Example 1 A1="" A2="" therefore A3="" Example 2 A1=5.5 A2="" therefore A3=X Example 3 A1="" A2=Kevin therefore A3=X Example 4 A1=5.5 A2=Kevin therefore A3=X Thank you in advance. Kevin Knight -- kevinknight09 ------------------------------------------------------------------------ kevinknight09's Profile: http://www.excelforum.com/member.php...o&userid=37024 View this thread: http://www.excelforum.com/showthread...hreadid=567602 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
| Linking two IF statements together | Excel Discussion (Misc queries) | |||
| Logical ELSE statements | Excel Discussion (Misc queries) | |||
| Nested IF statements | Excel Worksheet Functions | |||
| If statements | Excel Worksheet Functions | |||
Linear Mode
