LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display error message if a cell is left blank Another Excel User Excel Discussion (Misc queries) 8 February 11th 08 09:02 PM
How to point to (select) a cell to the left from a cell where I enter the = equal sign? Dmitry Excel Discussion (Misc queries) 4 June 30th 06 06:49 AM
how to display zero at the left hand of a code in a cell say 045 Marie Excel Discussion (Misc queries) 3 June 12th 06 10:41 AM
Find text within cell then display text to left Jambruins Excel Discussion (Misc queries) 5 April 17th 06 10:01 PM
with Autofilter on, display count results in lower left corner wit jsky Excel Worksheet Functions 1 October 3rd 05 10:46 PM


All times are GMT +1. The time now is 06:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"