If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
formula for excel spreadsheet
I am trying to creat a formula in my accounting spreadsheet that will put the
total in the appropriate column by the date column plus 0-30 days or next column plus 31-60 days. I tried the sumif and kept getting errors. Help. |
#2
|
|||
|
|||
formula for excel spreadsheet
Hi,
could you provide an example thanks "Pam" wrote: I am trying to creat a formula in my accounting spreadsheet that will put the total in the appropriate column by the date column plus 0-30 days or next column plus 31-60 days. I tried the sumif and kept getting errors. Help. |
#3
|
|||
|
|||
formula for excel spreadsheet
column c is a date format, column d is the total column, each column after
that is 0-30, 31-60, 61-90, 91-119,120-150,150+ respectively. I would like the total in d to automatically transfer to each of these columns as the number of days increase from the original date. Is that possible? "Eduardo" wrote: Hi, could you provide an example thanks "Pam" wrote: I am trying to creat a formula in my accounting spreadsheet that will put the total in the appropriate column by the date column plus 0-30 days or next column plus 31-60 days. I tried the sumif and kept getting errors. Help. |
#4
|
|||
|
|||
formula for excel spreadsheet
I tried this formula and got the result for one column, however when I
changed the date past 30 days it did not change the results. =IF(C6+(0-30),D6,0) "Eduardo" wrote: Hi, could you provide an example thanks "Pam" wrote: I am trying to creat a formula in my accounting spreadsheet that will put the total in the appropriate column by the date column plus 0-30 days or next column plus 31-60 days. I tried the sumif and kept getting errors. Help. |
#5
|
|||
|
|||
formula for excel spreadsheet
Hi,
in the column of 0-30 enter =IF((TODAY()-$C$3)=30,$D3,"") 31-60 =IF(AND((TODAY()-$C$3)30,(TODAY()-$C$3)=60),$D3,"") 61-90 =IF(AND((TODAY()-$C$3)60,(TODAY()-$C$3)=90),$D3,"") 91-119 =IF(AND((TODAY()-$C$3)90,(TODAY()-$C$3)=119),$D3,"") 120-150 =IF(AND((TODAY()-$C$3)119,(TODAY()-$C$3)=150),$D3,"") +150 =IF(AND((TODAY()-$C$3)119,(TODAY()-$C$3)=150),$D3,"") then copy formulas down "Pam" wrote: column c is a date format, column d is the total column, each column after that is 0-30, 31-60, 61-90, 91-119,120-150,150+ respectively. I would like the total in d to automatically transfer to each of these columns as the number of days increase from the original date. Is that possible? "Eduardo" wrote: Hi, could you provide an example thanks "Pam" wrote: I am trying to creat a formula in my accounting spreadsheet that will put the total in the appropriate column by the date column plus 0-30 days or next column plus 31-60 days. I tried the sumif and kept getting errors. Help. |
#6
|
|||
|
|||
formula for excel spreadsheet
opps I found a mistake use this ones in each column and then copy
=IF((TODAY()-$C3)=30,$D3,"") =IF(AND((TODAY()-$C3)30,(TODAY()-$C3)=60),$D3,"") =IF(AND((TODAY()-$C3)60,(TODAY()-$C3)=90),$D3,"") =IF(AND((TODAY()-$C3)90,(TODAY()-$C3)=119),$D3,"") =IF(AND((TODAY()-$C3)119,(TODAY()-$C3)=150),$D3,"") =IF((TODAY()-$C$3)150,$D3,"") "Eduardo" wrote: Hi, in the column of 0-30 enter =IF((TODAY()-$C$3)=30,$D3,"") 31-60 =IF(AND((TODAY()-$C$3)30,(TODAY()-$C$3)=60),$D3,"") 61-90 =IF(AND((TODAY()-$C$3)60,(TODAY()-$C$3)=90),$D3,"") 91-119 =IF(AND((TODAY()-$C$3)90,(TODAY()-$C$3)=119),$D3,"") 120-150 =IF(AND((TODAY()-$C$3)119,(TODAY()-$C$3)=150),$D3,"") +150 =IF(AND((TODAY()-$C$3)119,(TODAY()-$C$3)=150),$D3,"") then copy formulas down "Pam" wrote: column c is a date format, column d is the total column, each column after that is 0-30, 31-60, 61-90, 91-119,120-150,150+ respectively. I would like the total in d to automatically transfer to each of these columns as the number of days increase from the original date. Is that possible? "Eduardo" wrote: Hi, could you provide an example thanks "Pam" wrote: I am trying to creat a formula in my accounting spreadsheet that will put the total in the appropriate column by the date column plus 0-30 days or next column plus 31-60 days. I tried the sumif and kept getting errors. Help. |
#7
|
|||
|
|||
formula for excel spreadsheet
in last formula use
=IF((TODAY()-$C3)150,$D3,"") the problem was that I enter C between $ so the calculation will always look to that cell "Eduardo" wrote: opps I found a mistake use this ones in each column and then copy =IF((TODAY()-$C3)=30,$D3,"") =IF(AND((TODAY()-$C3)30,(TODAY()-$C3)=60),$D3,"") =IF(AND((TODAY()-$C3)60,(TODAY()-$C3)=90),$D3,"") =IF(AND((TODAY()-$C3)90,(TODAY()-$C3)=119),$D3,"") =IF(AND((TODAY()-$C3)119,(TODAY()-$C3)=150),$D3,"") =IF((TODAY()-$C$3)150,$D3,"") "Eduardo" wrote: Hi, in the column of 0-30 enter =IF((TODAY()-$C$3)=30,$D3,"") 31-60 =IF(AND((TODAY()-$C$3)30,(TODAY()-$C$3)=60),$D3,"") 61-90 =IF(AND((TODAY()-$C$3)60,(TODAY()-$C$3)=90),$D3,"") 91-119 =IF(AND((TODAY()-$C$3)90,(TODAY()-$C$3)=119),$D3,"") 120-150 =IF(AND((TODAY()-$C$3)119,(TODAY()-$C$3)=150),$D3,"") +150 =IF(AND((TODAY()-$C$3)119,(TODAY()-$C$3)=150),$D3,"") then copy formulas down "Pam" wrote: column c is a date format, column d is the total column, each column after that is 0-30, 31-60, 61-90, 91-119,120-150,150+ respectively. I would like the total in d to automatically transfer to each of these columns as the number of days increase from the original date. Is that possible? "Eduardo" wrote: Hi, could you provide an example thanks "Pam" wrote: I am trying to creat a formula in my accounting spreadsheet that will put the total in the appropriate column by the date column plus 0-30 days or next column plus 31-60 days. I tried the sumif and kept getting errors. Help. |
#8
|
|||
|
|||
formula for excel spreadsheet
hi,
see the formulas given before my two last post "Pam" wrote: I tried this formula and got the result for one column, however when I changed the date past 30 days it did not change the results. =IF(C6+(0-30),D6,0) "Eduardo" wrote: Hi, could you provide an example thanks "Pam" wrote: I am trying to creat a formula in my accounting spreadsheet that will put the total in the appropriate column by the date column plus 0-30 days or next column plus 31-60 days. I tried the sumif and kept getting errors. Help. |
#9
|
|||
|
|||
formula for excel spreadsheet
Thank you Eduardo, I was out of the office for a couple of days. I will try
the formulas and let you know. "Eduardo" wrote: in last formula use =IF((TODAY()-$C3)150,$D3,"") the problem was that I enter C between $ so the calculation will always look to that cell "Eduardo" wrote: opps I found a mistake use this ones in each column and then copy =IF((TODAY()-$C3)=30,$D3,"") =IF(AND((TODAY()-$C3)30,(TODAY()-$C3)=60),$D3,"") =IF(AND((TODAY()-$C3)60,(TODAY()-$C3)=90),$D3,"") =IF(AND((TODAY()-$C3)90,(TODAY()-$C3)=119),$D3,"") =IF(AND((TODAY()-$C3)119,(TODAY()-$C3)=150),$D3,"") =IF((TODAY()-$C$3)150,$D3,"") "Eduardo" wrote: Hi, in the column of 0-30 enter =IF((TODAY()-$C$3)=30,$D3,"") 31-60 =IF(AND((TODAY()-$C$3)30,(TODAY()-$C$3)=60),$D3,"") 61-90 =IF(AND((TODAY()-$C$3)60,(TODAY()-$C$3)=90),$D3,"") 91-119 =IF(AND((TODAY()-$C$3)90,(TODAY()-$C$3)=119),$D3,"") 120-150 =IF(AND((TODAY()-$C$3)119,(TODAY()-$C$3)=150),$D3,"") +150 =IF(AND((TODAY()-$C$3)119,(TODAY()-$C$3)=150),$D3,"") then copy formulas down "Pam" wrote: column c is a date format, column d is the total column, each column after that is 0-30, 31-60, 61-90, 91-119,120-150,150+ respectively. I would like the total in d to automatically transfer to each of these columns as the number of days increase from the original date. Is that possible? "Eduardo" wrote: Hi, could you provide an example thanks "Pam" wrote: I am trying to creat a formula in my accounting spreadsheet that will put the total in the appropriate column by the date column plus 0-30 days or next column plus 31-60 days. I tried the sumif and kept getting errors. Help. |
#10
|
|||
|
|||
formula for excel spreadsheet
without being too much of a pain, can you explain the formula. It worked
great!!! "Eduardo" wrote: in last formula use =IF((TODAY()-$C3)150,$D3,"") the problem was that I enter C between $ so the calculation will always look to that cell "Eduardo" wrote: opps I found a mistake use this ones in each column and then copy =IF((TODAY()-$C3)=30,$D3,"") =IF(AND((TODAY()-$C3)30,(TODAY()-$C3)=60),$D3,"") =IF(AND((TODAY()-$C3)60,(TODAY()-$C3)=90),$D3,"") =IF(AND((TODAY()-$C3)90,(TODAY()-$C3)=119),$D3,"") =IF(AND((TODAY()-$C3)119,(TODAY()-$C3)=150),$D3,"") =IF((TODAY()-$C$3)150,$D3,"") "Eduardo" wrote: Hi, in the column of 0-30 enter =IF((TODAY()-$C$3)=30,$D3,"") 31-60 =IF(AND((TODAY()-$C$3)30,(TODAY()-$C$3)=60),$D3,"") 61-90 =IF(AND((TODAY()-$C$3)60,(TODAY()-$C$3)=90),$D3,"") 91-119 =IF(AND((TODAY()-$C$3)90,(TODAY()-$C$3)=119),$D3,"") 120-150 =IF(AND((TODAY()-$C$3)119,(TODAY()-$C$3)=150),$D3,"") +150 =IF(AND((TODAY()-$C$3)119,(TODAY()-$C$3)=150),$D3,"") then copy formulas down "Pam" wrote: column c is a date format, column d is the total column, each column after that is 0-30, 31-60, 61-90, 91-119,120-150,150+ respectively. I would like the total in d to automatically transfer to each of these columns as the number of days increase from the original date. Is that possible? "Eduardo" wrote: Hi, could you provide an example thanks "Pam" wrote: I am trying to creat a formula in my accounting spreadsheet that will put the total in the appropriate column by the date column plus 0-30 days or next column plus 31-60 days. I tried the sumif and kept getting errors. Help. |
Thread Tools | |
Display Modes | |
|
|