Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I write an if-then formula for 0 or less than 0 in cell t.
I am trying to write an if-then formula for a cell that if the formula causes
the cell ballance to become 0 or less than 0, then the formaula will be referred to another cell to complete the application. (i.e. subtract cell C5 from cell D3. if cell D3 becomes 0 or less than 0, then subtract the remainder from cell D4. If D4 becomes 0 or less than 0, then subtract the remainder from cell D5). I am using office 2000 SR-1 Professional |
#2
|
|||
|
|||
I'm not sure exactly what you're after, but if you put this in E3:
=MAX(SUM($D$3:D3)-$C$5,0) and copy down to E5, then the results will return the highest of the cumulative remainder or 0. For instance the formula above would return C D E 3 10 0 4 10 7 5 13 10 10 In article , "Baz1" wrote: I am trying to write an if-then formula for a cell that if the formula causes the cell ballance to become 0 or less than 0, then the formaula will be referred to another cell to complete the application. (i.e. subtract cell C5 from cell D3. if cell D3 becomes 0 or less than 0, then subtract the remainder from cell D4. If D4 becomes 0 or less than 0, then subtract the remainder from cell D5). I am using office 2000 SR-1 Professional |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
How do I do math on a cell name in formula? | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |