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

Thanks,

DFA

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?

MIKE

It worked! Thank you very much.

re: " ...and the formula should be in the J100 cell"The key point here is that you can not use an Excel formula to

writea 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.

Ask Your Question

Weekly Poll

Do you think Europe's new data protection laws will affect you?

Discuss in The Lounge

Poll History