Showing the cell to the Left when certain criteria are met

[cmatera]

Ok so here's another one. I have 3 cells that I'm concerned with:

ET (Q2), Used (R2), Balance (S2)


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 Q2, I want
to display the balance from cell P2 in my cell D57.

I should also say that Balance is ALWAYS to the left of ET in my
spreadsheet...so if you can visualize the columns:

ET (N2) | USED (O2) | BALANCE (P2) | ET (Q2) | USED (R2) | BALANCE
(S2)

Otherwise I want to put a zero...or do something else...Any ideas?

Thanks

Chris

 

[Spiky]

Ok so here's another one. I have 3 cells that I'm concerned with:

ET (Q2), Used (R2), Balance (S2)

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 Q2, I want
to display the balance from cell P2 in my cell D57.

I should also say that Balance is ALWAYS to the left of ET in my
spreadsheet...so if you can visualize the columns:

ET (N2) | USED (O2) | BALANCE (P2) | ET (Q2) | USED (R2) | BALANCE
(S2)

Otherwise I want to put a zero...or do something else...Any ideas?

Thanks

Chris

in P2: =IF(Q2=0,0,your_calc)
Copy to every "balance" cell in the sheet.

 

[Spiky]

Or maybe I read that wrong.

in D57: =IF(Q2=0,0,P2)