Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to do a formula in Excel until the value is 0
I am trying to do the following formula in Excel:
=IF(D224=0,E223+B224,E223-D224) I want to do this until the value of Column E = 0, if it does I want it to display "Current" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to do a formula in Excel until the value is 0
Try inserting the additional IF check in front, viz:
=IF(E223=0,"Current",IF(D224=0,E223+B224,E223-D224)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- wrote in message ... I am trying to do the following formula in Excel: =IF(D224=0,E223+B224,E223-D224) I want to do this until the value of Column E = 0, if it does I want it to display "Current" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to do a formula in Excel until the value is 0
I have no idea what you're trying to accomplish. Could you explain it
better? If your formula is in cell A1 your formula is saying that if D224 is 0, then add B224 to E223 and return the value to cell A1; if D224 is not 0 then subtract D224 from E223 and return the value to cell A1. What do you mean by Column E = 0? All of the cells in column E? Tyro wrote in message ... I am trying to do the following formula in Excel: =IF(D224=0,E223+B224,E223-D224) I want to do this until the value of Column E = 0, if it does I want it to display "Current" |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to do a formula in Excel until the value is 0
That does not work correctly I need it to do the first IF, calculate
until E223=0 On Mar 25, 7:13*pm, "Max" wrote: Try inserting the additional IF check in front, viz: =IF(E223=0,"Current",IF(D224=0,E223+B224,E223-D224)) -- Max Singaporehttp://savefile.com/projects/236895 xdemechanik wrote in message ... I am trying to do the following formula in Excel: =IF(D224=0,E223+B224,E223-D224) I want to do this until the value of Column E = 0, if it does I want it to display "Current"- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to do a formula in Excel until the value is 0
Here is an example of the cells:
A B C D E Due Date Total Current due Date Received Current amount paid Current Amount Behind 6/17/2005 $200.00 $0.00 $200 7/1/2005 $200.00 $0.00 $400 7/15/2005 $200.00 $0.00 $600 7/29/2005 $200.00 8/5/2005 $200.00 $400 If D shows no Payment amount or $0.00 then Add amount from B $200 Once D shows an amount Subtract that amount from previous E amount This will continue down E until E finally = 0.00 which would be current. Then it continues, if D shows 0 then it adds amount from B to E On Mar 25, 7:17*pm, "Tyro" wrote: I have no idea what you're trying to accomplish. Could you explain it better? If your formula is in cell A1 your formula is saying that if D224 is 0, then add B224 to E223 and return the value to cell A1; if D224 is not 0 then subtract D224 from E223 and return the value to cell A1. *What do you mean by Column E = 0? All of the cells in column E? Tyro wrote in message ... I am trying to do the following formula in Excel: =IF(D224=0,E223+B224,E223-D224) I want to do this until the value of Column E = 0, if it does I want it to display "Current"- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to do a formula in Excel until the value is 0
Assuming data as posted in cols A to E, from row2 down
In E2: =IF(D20,B2-D2,B2) In E3: =IF(D30,E2-D3,SUM(E2,B3)) Copy E3 down. This seems to give the results that you posted. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- wrote in message ... Here is an example of the cells: A B C D E Due Date Total Current due Date Received Current amount paid Current Amount Behind 6/17/2005 $200.00 $0.00 $200 7/1/2005 $200.00 $0.00 $400 7/15/2005 $200.00 $0.00 $600 7/29/2005 $200.00 8/5/2005 $200.00 $400 If D shows no Payment amount or $0.00 then Add amount from B $200 Once D shows an amount Subtract that amount from previous E amount This will continue down E until E finally = 0.00 which would be current. Then it continues, if D shows 0 then it adds amount from B to E |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |