addition to a remote cell

T

TBob

How can I write a formula to increase a different cell by 1 if an IF
ststement is true?
 
O

Otto Moehrbach

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
 
T

TBob

I thought so. Thank you.
--
Tucson Bob


Otto Moehrbach said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
I'm John, My first post. 0
Excel - Wich Function should I use? 1
Drop down list control value in vba 2
Excel does not accept text format! 0
Pasting a cell into bookmarked table from excel vba 1
v look up and if statement 4
Visio: copy text of a master shape to User-define Cells (Variable) 0

Top