问题描述:

=IF(D3="+";I3("test1");I3("test1"))

The cell with the code just says "#REF!"

Its probably a sintax error..

What i want is: If the cell D3 is equal to "+" then the value of the cell I3 must be equal to "test1"

网友答案:

What you are asking for is impossible using formulas.

A formula can only alter the cell it is written in, it cannot alter any other cell.

Use of vba would be required to make this type of change.

网友答案:

It's syntax. Remove the () in the True, False components and use commas, not semicolons. Type this formula in Cell I3.

=IF(D3="+","test1", "")
相关阅读:
Top