Solved Excel 2007 if formula

May 10, 2011 at 13:05:13
Specs: Windows XP
I am trying to create a n IF formula in Excel 2007 based on the following but it is not working:

=IF(H100 = "X", (J100 = " Analysis Required", " ")

What I am trying to say is IF Cell H100 = X, then cell J100 should display the words "Anaysis Required." If not, then cell J100 should be blank. Please tell me what I am doing wrong because it keeps coming back with #NAME?.


See More: Excel 2007 if formula

Report •

May 10, 2011 at 15:29:21
✔ Best Answer
The format of the =IF() function is:

=IF ( logical_test, value_if_true, value_if_false )

Yours is very close:

=IF(H100 = "X", (J100 = " Analysis Required", " ")

just remove the odd left paren, and you get:

=IF(H100 = "X", J100 = " Analysis Required", " ")

Actually, it should be:

=IF(H100 = "X", "Analysis Required", " ") and the formula should be in the J100 cell.

Is that what your looking for?


Report •

May 12, 2011 at 05:31:30
It worked! Thank you very much.

Report •

May 12, 2011 at 09:44:07
re: "...and the formula should be in the J100 cell"

The key point here is that you can not use an Excel formula to write a value into another cell.

The cell where you want a given result must contain the formula that returns that result.

The only way to "automatically" put a value in a cell that does not contain a formula is with VBA code, i.e. a macro.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question