Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use Input cell and or view as a display cell
How can one alter a cell from calculation in another cell?
What is wrong with this IF function? I have a hidden column (column K), in one of the cells I am trying to calculate if a total dollar amount in column N(not hidden), if that value is equal to $0.00. Then another cell in column J(not hidden) is equal to another cell in column C (not hidden). My statement is as follows: =IF(N56=0,J57=C57,j57=0). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use Input cell and or view as a display cell
Bob,
A function cannot change any other cell. It can only return a result in to the cell which called it. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "bob" wrote in message ... How can one alter a cell from calculation in another cell? What is wrong with this IF function? I have a hidden column (column K), in one of the cells I am trying to calculate if a total dollar amount in column N(not hidden), if that value is equal to $0.00. Then another cell in column J(not hidden) is equal to another cell in column C (not hidden). My statement is as follows: =IF(N56=0,J57=C57,j57=0). |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use Input cell and or view as a display cell
Hi
formulas can't change other cells. They can only return a value to the cell in which they reside -- Regards Frank Kabel Frankfurt, Germany "bob" schrieb im Newsbeitrag ... How can one alter a cell from calculation in another cell? What is wrong with this IF function? I have a hidden column (column K), in one of the cells I am trying to calculate if a total dollar amount in column N(not hidden), if that value is equal to $0.00. Then another cell in column J(not hidden) is equal to another cell in column C (not hidden). My statement is as follows: =IF(N56=0,J57=C57,j57=0). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Input cell should display a percentage of input value in the cell | Excel Discussion (Misc queries) | |||
Cell display after input | Excel Discussion (Misc queries) | |||
Cell Input ~ Display | Excel Discussion (Misc queries) | |||
Code to Query SQL Server with a parameter value (entered into an Input Box), and have that value also display in a selected cell on a worksheet | Excel Worksheet Functions | |||
How to display contents of a cell in UserForm and take input | Excel Programming |