If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Display a cell to the left with some changes
Ok so here's another one. I have 3 cells that I'm concerned with:
ET (A2), Used (B2), Balance (C2) If it's the begining of the month ET is filled with a number (10,13,20) otherwise it's 0 If a person uses time used will be filled in with a number, otherwise it's 0 Balance is a running calculation based on the ammount of time left - it could be negative. Here's what I want to do in cell D57 If ET has a number in it i.e.: it's 0 Then I want to display the Balance cell to the left of ET so for example if ET is cell C2, I want to display the balance from cell B2 in my cell D57. Otherwise I want to put a zero...or do something else...Any ideas? Thanks Chris |
#2
|
|||
|
|||
Display a cell to the left with some changes
This is probably simple, cmatera, but here's what confuses me: You say that
ET is in column A, but then say you want to "display theBalance cell to the left of ET". Whether you mean you want to display it to the left of ET, or display the cell that is to the left of ET, there's nothing to the left of column A. What am I missing? --- "cmatera" wrote: Ok so here's another one. I have 3 cells that I'm concerned with: ET (A2), Used (B2), Balance (C2). If it's the begining of the month ET is filled with a number (10,13,20) otherwise it's 0 If a person uses time used will be filled in with a number, otherwise it's 0 Balance is a running calculation based on the ammount of time left - it could be negative. Here's what I want to do in cell D57: If ET has a number in it ie it's 0 Then I want to display theBalance cell to the left of ET so for example if ET is cell C2, I want to display the balance from cell B2 in my cell D57. Otherwise I want to put a zero...or do something else. |
Thread Tools | |
Display Modes | |
|
|