If statement needed to solve

  • Thread starter Thread starter kenkane79
  • Start date Start date
K

kenkane79

I am taking a class and cannot figure this out at all. I understan
what is wanted but cannot seem to figure it out. If anybody can hel
me that would be so great. Thanks

Ken

06) For 10 points, add another sheet and name it AR Aging. Beginning i
cell A1, create the following Accounts Receivable aging problem. Wide
column A appropriately. Use cell C1 for the =now() statement. Format i
as date. For the remainder of the problem, use columns B through G. Pu
the Totals caption in column A, two rows below the row in which th
$6500 entry appears. The =now() functions entered in the invoice dat
column are used to generate dates that set up the problem. Afte
entering, format them as dates.

Today's date: =now()
Client Amount Invoice Date Current Over 30 Over 60 Over 90
$5400 =now()-47
$3000 =now()-72
$4000 =now()-104
$2500 =now()-24
$6500 =now()-38
Totals:


To solve this, an =IF statement is required for each column. Fo
example, in the Over 30 column, the logic of the statement is a
follows: If the difference between today's date and the date of th
invoice is greater than 30 and equal to or less than 60, the amoun
goes into this column. To get the amount into the Current column, th
difference between the two dates must be less than or equal to 30. T
get into the over 90 column, the difference between the two dates mus
be greater than 90. You can figure out the over sixty column. Save th
workboo
 
I really want to help, but I'm not going to do your homework for you!

Here's a hint, though: you can "nest" IF statements to work together.
Just as plastic cups nest inside each other when they're stacked, you
can nest IF statements. As you know, an IF statement evaluates a
logical expression, then returns one answer if the logical expression
is true and another if the expression is false.

If I do my laundry on Mondays, then here's how I would decide whether
or not to do laundry:
=IF(today = monday, do laundry, don't do laundry)
The logical expression is "today = monday"; if today = monday is true,
then do laundry; if today is not monday, then don't do laundry.

A nested IF statement is an IF within an IF. The "inner" IF is
complete by itself, and contains all the usual components of an IF
statement; the difference is the inner IF replaces either the True or
the False response from the outer IF.

In the example above, I need to have enough quarters to do my laundry:
=IF(my pockets contain quarters, go to laundromat, find quarters)
English translation: If I have enough quarters (the logical
expression), go to the laundry, or else find quarters.

Here's how to nest those IFs:
=IF(today = monday, IF(my pockets contain quarters, go to laundromat,
find quarters), don't do laundry)

If today is Monday and I have quarters, I'll go the laundry.
If today is Monday and I'm out of quarters, I'll find quarters.
If today is not Monday I won't do laundry.

Hope this does it for ya!
 
Back
Top