If, Then Statements

[Scottie318]

I am having trouble once again in writing an IF, THEN statement. I have
to create a sheet on invoices and aging. In column A, I have the
labels such as Fred's Music Store. In column B, I have Invoice Date,
for example =NOW()-72 and Column C has invoice amount of $432.78. Then
there are four columns Current, Over 30, Over 60, and Over 90
respectively.

My instructions are as follows:

To solve this, an =IF statement is required for each column. For
example, in the Over 30 column, the logic of the statement is as
follows: If the difference between today's date and the date of the
invoice is greater than 30 and equal to or less than 60, the amount
goes into this column. To get the amount into the Current column, the
difference between the two dates must be less than 30. To get into the
over 90 column, the difference between the dates must be greater than
90. You can figure out the over 60 column.

Can anyone PLEASE help me. I really need to do well on this work and
my mind is drawing blanks on IF, then statements.

Anyone?

Thanks
Scott

 

[OZZIE]

Scott -

you'll need to expand on this formula to include less then
90 and greater then 60, then 60 and 30, but here's the
over 90...

I have changed =now -72 to cell reference D1.

=IF(DAYS360($B2,$D$1)>90,+$C2,0)


hope it helps you get started..

 

[Loretta Jean]

Scottie,

I tried to send an Excel file to your email, but it was
returned. Here are the statements

Column Headers:
Column A --- Company Name
Column B --- Invoice Date
Column C --- Amount
Column D --- Current
Column E --- Over 30
Column F --- Over 60
Column G --- Over 90


Here are the formulas, assuming the first record starts on
row 2:

Column D --- =IF(TODAY()-$B2<=30,$C2,0)
Column E --- =IF(AND(TODAY()-$B2>=31,TODAY()-
$B2<=60),$C2,0)
Column F --- =IF(AND(TODAY()-$B2>=61,TODAY()-
$B2<=90),$C2,0)
Column G --- =IF(TODAY()-$B2>=91,$C2,0)


Hope this helps!

 

[OZZIE]

HAD MORE TIME TO FINISH THE REST OF THE ANSWER..
CELL D2 =IF(DAYS360($B2,$I$1)<30,+$C2,0)

CELL E2 =IF(AND(DAYS360($B2,$I$1)<59,(DAYS360($B2,$I$1)

30)),+$C2,0)

CELL F2 =IF(AND(DAYS360($B2,$I$1)>60,(DAYS360($B2,$I$1)
<90)),+$C2,0)

CELL G2 =IF(DAYS360($B2,$I$1)>90,+$C2,0)


DATE USED IN CELL I1 WAS 10/31/2003

 

[Scottie]

Loretta,

I appreciate the help. Can you try sending the file again? Either
(e-mail address removed) or (e-mail address removed).

Thanks!
Scott

 

[Scottie]

Ozzie,

Is there anyway you can send me the excel sheet if possible? My email is
(e-mail address removed) or (e-mail address removed)

I'm also ScottieMobility on AIM.

Thanks
Scott

 

[OZZIE]

SCOTT, SENT INFORMATION TO YOUR EMAIL ADDRESS - AS SCOTTS
AGING SCHEDULE.

IF YOU HAVE BEEN HELPED, PASS ON SOME HELP TO SOMEONE ELSE.


HAVE FUN.