当前位置: 动力学知识库 > 问答 > 编程问答 >

Atributing a value to a cell - Excel

问题描述:

=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", "")
分享给朋友:
您可能感兴趣的文章:
随机阅读: