| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel TCP/IP spreadsheet formula help | Excel Discussion (Misc queries) | |||
| Percentage formula in Excel spreadsheet | New Users to Excel | |||
| Excel spreadsheet formula | Excel Worksheet Functions | |||
| Urgent - how to set a formula in excel spreadsheet | Excel Worksheet Functions | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
Linear Mode
