| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
addition to a remote cell
How can I write a formula to increase a different cell by 1 if an IF
ststement is true? -- Tucson Bob |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
addition to a remote cell
Bob
A formula can only return a value, and it can do so only in the cell in which the formula resides. If you cannot place a formula into the cell you want to add 1 to, you will need to do it via VBA. HTH Otto "TBob" wrote in message ... How can I write a formula to increase a different cell by 1 if an IF ststement is true? -- Tucson Bob |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
addition to a remote cell
I thought so. Thank you.
-- Tucson Bob "Otto Moehrbach" wrote: Bob A formula can only return a value, and it can do so only in the cell in which the formula resides. If you cannot place a formula into the cell you want to add 1 to, you will need to do it via VBA. HTH Otto "TBob" wrote in message ... How can I write a formula to increase a different cell by 1 if an IF ststement is true? -- Tucson Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove value from remote cell | Excel Discussion (Misc queries) | |||
| Filtering with criteria in an remote cell | Excel Programming | |||
| forcing value into remote cell | Excel Discussion (Misc queries) | |||
| REMOTE CELL FUNCTION | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Linear Mode
