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

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.