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 |
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 |
All times are GMT +1. The time now is 05:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com