Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display error message if a cell is left blank | Excel Discussion (Misc queries) | |||
How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
how to display zero at the left hand of a code in a cell say 045 | Excel Discussion (Misc queries) | |||
Find text within cell then display text to left | Excel Discussion (Misc queries) | |||
with Autofilter on, display count results in lower left corner wit | Excel Worksheet Functions |