Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Aging Formula
Have the following formula for aging, would like for it to age credit
balances in the current column. Can I add something to these formulas to make it work Cell Q1 is date to age from, Cell G2 is invoice date, cell H2 is invoice balance. formula for Current column =IF($Q$1=($G2+1),IF($Q$1<=($G2+30),$H2,""),"") formula for 1-30 Days Past Due =IF($Q$1=($G2+31),IF($Q$1<=($G2+60),$H2,""),"") |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Aging Formula
What's wrong with what you have? It looks like a decent aging formula to me.
Regards, Fred. "Sue" wrote in message ... Have the following formula for aging, would like for it to age credit balances in the current column. Can I add something to these formulas to make it work Cell Q1 is date to age from, Cell G2 is invoice date, cell H2 is invoice balance. formula for Current column =IF($Q$1=($G2+1),IF($Q$1<=($G2+30),$H2,""),"") formula for 1-30 Days Past Due =IF($Q$1=($G2+31),IF($Q$1<=($G2+60),$H2,""),"") |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Aging Formula
I need to be able to tell if it the amount in cell H2 is less than 0(and
greater than 0) it goes in current column, in all the other aging columns the amount has to be greater than 0 "Fred Smith" wrote: What's wrong with what you have? It looks like a decent aging formula to me. Regards, Fred. "Sue" wrote in message ... Have the following formula for aging, would like for it to age credit balances in the current column. Can I add something to these formulas to make it work Cell Q1 is date to age from, Cell G2 is invoice date, cell H2 is invoice balance. formula for Current column =IF($Q$1=($G2+1),IF($Q$1<=($G2+30),$H2,""),"") formula for 1-30 Days Past Due =IF($Q$1=($G2+31),IF($Q$1<=($G2+60),$H2,""),"") |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Aging Formula
So if H2 is less than zero, or the age is less than 31 days, it's current,
right? If so, try: =if(or($h2<=0,$q$1<=$g2+30),$h2,"") In the aging columns, try: =if(and($h20,$q$1$g2+30,$q$1<=$g2+60),$h2,"") Regards, Fred. "Sue" wrote in message ... I need to be able to tell if it the amount in cell H2 is less than 0(and greater than 0) it goes in current column, in all the other aging columns the amount has to be greater than 0 "Fred Smith" wrote: What's wrong with what you have? It looks like a decent aging formula to me. Regards, Fred. "Sue" wrote in message ... Have the following formula for aging, would like for it to age credit balances in the current column. Can I add something to these formulas to make it work Cell Q1 is date to age from, Cell G2 is invoice date, cell H2 is invoice balance. formula for Current column =IF($Q$1=($G2+1),IF($Q$1<=($G2+30),$H2,""),"") formula for 1-30 Days Past Due =IF($Q$1=($G2+31),IF($Q$1<=($G2+60),$H2,""),"") |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Aging Formula
Thanks that worked wonderfully
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Aging Formula
You're welcome. Glad I could help.
Fred. "Sue" wrote in message ... Thanks that worked wonderfully |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Aging Formula | Excel Discussion (Misc queries) | |||
aging formula | Excel Discussion (Misc queries) | |||
aging | Excel Worksheet Functions | |||
WHAT FORMULA DO I USE FOR AGING A STATEMENT | Excel Worksheet Functions | |||
aging workbook | New Users to Excel |