Excel IF Formula Question

October 25, 2010 at 13:35:36
Specs: Windows 7
I am subtracting two numbers and having the answer put into a seperate cell. I then need to take that number and depending on the answer place an X in the appropriate age column.

I did this so far and it is not working but I do know how to fix it. f2-e2 in column h2.
In column i, I wrote =IF(h2=1,"X") It is the if statement that I am having the error show what am I doing wrong.

See More: Excel IF Formula Question

Report •

October 25, 2010 at 13:39:32
There is nothing wrong wth your formula that would produce an error.

What error are you getting?

Report •

October 25, 2010 at 13:42:12
I am getting an invalid name error

Report •

October 28, 2010 at 03:03:41
Make sure your formula is =IF(H2=1,"X") and not =IF(H2=1,X).
Without the " around the "X", you will get an #NAME? error.

Report •

Related Solutions

October 28, 2010 at 05:57:14
Copying your formula directly from your post into a spreadsheet causes no error for me.

There's no reason it should.

Report •

Ask Question