Notice: Payments for answers will end 4/10/2017. Click for more info.
You have new items in your feed. Click to view.
Question and answer
Q: Using Excel, given a list of contracts and due dates for annual maintenance fees. You wish to determine when you have a contract due in the next 45 days and provide a note that warns you that the
payment is due.
A: One way of providing a note could be with a formula like this on the place where you want the note to appear: =IF(TODAY()+45>A1,"Warning: Payment is coming due","") Change the reference from A1 to the cell with the due date. [ You can format the cell as you want, to make sure that the note is visible. ]
Expert answered|unknown23|Points 60|
Question
Asked 11/12/2012 5:52:37 PM
0 Answers/Comments
Get an answer
New answers
Rating

There are no new answers.

Comments

There are no comments.

Add an answer or comment
Log in or sign up first.
26,646,381 questions answered
Popular Conversations
Suppose the U.S. can produce cars for a lower opportunity cost than ...
Weegy: Suppose the U.S. can produce cars for a lower opportunity cost than Japan while Japan has a comparative ...
2/13/2018 7:30:37 PM| 4 Answers
What's the simplified form of 2x + 3 x + 5? A. x 8 B. ...
Weegy: (2x^2)(3x^2) = 6x4 User: Simplify this expression: 13 + (–12) – (–5) = ? A. –6 B. 6 C. –30 ...
2/12/2018 11:53:02 PM| 3 Answers
Simplify and solve this equation for q: 3q + 5 + 2q – 5 = 65. ...
Weegy: 3q + 5 + 2q - 5 = 65 User: Solve the following inequality: 38 4 B. x 28 Weegy: 38 User: Use an ...
2/19/2018 12:26:32 AM| 3 Answers
Solve this equation: 80 = 3y + 2y + 4 + 1. A. y = 1/5 B. ...
Weegy: 80 = 3y + 2y + 4 + 1 80 = 5y + 5 80 - 5 = 5y -5y = -75 y = 15 User: Solve the inequality: 12p + 7 > 139 ...
2/14/2018 2:20:46 PM| 3 Answers
Solve the equation: 12y = 132. A. y = 11 B. y = 144 ...
Weegy: 12y = 132 User: Solve this equation: 2s + s + 12 = 132. A. s = 40 B. s = –30 C. s = 9 D. ...
2/14/2018 2:32:47 PM| 3 Answers
Weegy Stuff
S
L
Points 369 [Total 372] Ratings 11 Comments 229 Invitations 3 Offline
S
Points 89 [Total 89] Ratings 0 Comments 19 Invitations 7 Offline
S
P
L
P
P
Points 55 [Total 248] Ratings 0 Comments 55 Invitations 0 Offline
S
P
Points 41 [Total 85] Ratings 1 Comments 31 Invitations 0 Offline
S
1
L
L
P
R
P
L
P
P
R
Points 38 [Total 12649] Ratings 0 Comments 38 Invitations 0 Offline
S
Points 20 [Total 20] Ratings 2 Comments 0 Invitations 0 Online
S
P
Points 13 [Total 30] Ratings 0 Comments 13 Invitations 0 Offline
S
Points 11 [Total 11] Ratings 1 Comments 1 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 0 Comments 0 Invitations 1 Offline
S
Points 10 [Total 11] Ratings 1 Comments 0 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.