| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Then Formula Question
I am pulling date into a cell and I want to use an IF statement to change the
date being brought back only if has a certain value. For Example: If(A2=0, "X") but if A2 is not equal to 0, I want it to bring back the value of A2. So if A2 is equal to 496, it should bring back 496. If A2 is equal to 0, it should bring back X. How do I speicfy this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Then Formula Question
=IF(A2=0,"X",A2)
Gord Dibben MS Excel MVP On Tue, 10 Mar 2009 12:23:02 -0700, IF Statement Values <IF Statement wrote: I am pulling date into a cell and I want to use an IF statement to change the date being brought back only if has a certain value. For Example: If(A2=0, "X") but if A2 is not equal to 0, I want it to bring back the value of A2. So if A2 is equal to 496, it should bring back 496. If A2 is equal to 0, it should bring back X. How do I speicfy this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Question | Excel Discussion (Misc queries) | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| Formula Question | Excel Discussion (Misc queries) | |||
| formula question | Excel Worksheet Functions | |||
| Formula Question | Excel Discussion (Misc queries) | |||
Linear Mode
