You have new items in your feed. Click to view.
Question and answer
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.
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.
Questions asked by the same visitor
In Excel: You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost.
Weegy: I will assume that you have Cost numbers in column A, Sales numbers in column B. Try this formula in cell C1: =if(B1>=1.2*A1, 0.06*B1,"") (More)
Question
Expert Answered
Asked 11/5/2012 6:14:51 PM
0 Answers/Comments
what are there some specific Excel skills that employers look for?
Weegy: Creating templates, using equations, merging documents to Word, formatting cells.... These are just a few that I use regularly and they're pretty basic. (More)
Question
Expert Answered
Asked 11/7/2012 12:24:32 PM
0 Answers/Comments
what are some specific Excel skills that employers look for?
Weegy: The most demanding one is to get "Relative capability" to do the required job, otherwise, an employer is not interested about the rest of strengths and weaknesses he just wants his work done. (More)
Question
Expert Answered
Asked 11/7/2012 12:26:42 PM
0 Answers/Comments
What are any other types of non-mathematical functions in Excel?
Weegy: Text and database (if you consider date&time to be mathematical)...... (More)
Question
Expert Answered
Asked 11/7/2012 3:06:45 PM
0 Answers/Comments
In Excel: calculate the total pay for an employee who receives regular time for 40 hours, time and a half for 40-50 hours, and double time for hours over 50.
Weegy: Here is a formula that would accomplish your goal. The formula assumes that hours are in A1, and base pay is in B2: =A1*B1+MAX(0,MIN(50,A1)-40)*B1*0.5+MAX(0,MIN(50,A1)-50)*B1 (More)
Question
Expert Answered
Asked 11/10/2012 9:55:06 AM
0 Answers/Comments
26,248,659 questions answered
Popular Conversations
Stopping the spread of communism was the top priority outlined in ...
Weegy: The Indian subcontinent was partitioned into India and Pakistan. User: The British replaced the Mughal ...
9/30/2016 9:57:58 AM| 2 Answers
Which of the following is true about wants? A. They include ...
Weegy: Which of the following is true about wants? A. They include items such as food and shelter. User: What is a ...
9/30/2016 1:52:17 PM| 2 Answers
Which part of eyes that give out the color?
9/30/2016 12:00:10 AM| 1 Answers
Which of the following is NOT an example of a visual? A. a diagram ...
Weegy: Which of the following is NOT an example of a visual is a chart listing results of a scientific study about ...
9/30/2016 12:26:06 AM| 1 Answers
Weegy Stuff
S
L
P
P
P
P
P
L
Points 1153 [Total 5225] Ratings 2 Comments 1133 Invitations 0 Offline
S
P
1
L
Points 841 [Total 1721] Ratings 9 Comments 751 Invitations 0 Offline
S
L
P
Points 235 [Total 1347] Ratings 0 Comments 235 Invitations 0 Online
S
Points 223 [Total 517] Ratings 0 Comments 223 Invitations 0 Offline
S
Points 105 [Total 105] Ratings 0 Comments 105 Invitations 0 Offline
S
L
P
P
P
Points 90 [Total 3952] Ratings 0 Comments 90 Invitations 0 Offline
S
Points 72 [Total 72] Ratings 0 Comments 72 Invitations 0 Offline
S
Points 30 [Total 30] Ratings 3 Comments 0 Invitations 0 Offline
S
L
Points 25 [Total 4250] Ratings 1 Comments 15 Invitations 0 Offline
S
Points 11 [Total 11] Ratings 1 Comments 1 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.