So the only is through macro?

"Chip Pearson" wrote in message
...
A worksheet formula cannot change the value of any other cell. It
can only return a value to the cell which contains the formula.

In cell K7, use the formula

=IF(H17=27759,"yes","no")



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"crapit" wrote in message
...
How do I indicate a cell value at other range?
I try something =IF(H17=27759,range("K7") = "yes",range("K7")
="no") but the
activecell give #name!