View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cmatera cmatera is offline
external usenet poster
 
Posts: 18
Default 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