If Then Formula Question

  • Thread starter IF Statement Values
  • Start date
I

IF Statement Values

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

Gord Dibben

=IF(A2=0,"X",A2)


Gord Dibben MS Excel MVP

On Tue, 10 Mar 2009 12:23:02 -0700, IF Statement Values <IF Statement
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs Function not giving desired result with date criteria 2
Calendar Logic: Recurring Dates 3
Excel check value i cell 6
Conditional Formatting Confusion... 2
Formulas Still Not Working 5
Vlookup and return sheet name also 2
median array help 2
Referring to a cell by using another cell for the row number 6

Top