ExcelBanter - If Then Formula Question

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

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

- - If Then Formula Question (https://www.excelbanter.com/excel-worksheet-functions/223789-if-then-formula-question.html)

IF Statement Values

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?

Gord Dibben

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?

All times are GMT +1. The time now is 11:47 AM.