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
In Excel: You wish to 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/5/2012 6:49:36 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
Are there any other types of non mathematical-function categories in Excel operations?
Weegy: Text and database (if you consider date&time to be mathematical). (More)
Question
Expert Answered
Asked 11/7/2012 12:38:51 PM
0 Answers/Comments
23,872,149 questions answered
Popular Conversations
Which word has a more negative connotation for the sentence ...
Weegy: We bought __________________ souvenirs at the amusement park: a. inexpensive. User: The dictionary meaning ...
2/7/2016 8:01:03 AM| 3 Answers
Both species benefit in the type of symbiosis called parasitism.
Weegy: Both species benefit in the type of symbiosis called parasitism. FALSE. User: Mutualism, commensalism, and ...
2/7/2016 9:25:53 AM| 3 Answers
You don't really approve of the idea of political parties. However, ...
Weegy: You don't really approve of the idea of political parties. However, you're known as a Federalist and are soon ...
2/7/2016 1:00:15 AM| 2 Answers
An organism’s particular role in its habitat, or how it makes its ...
Weegy: An organism's particular role in its habitat, or how it makes its living, is called its niche. User: An ...
2/7/2016 9:17:59 AM| 2 Answers
Which action associated with the United States' "return to normalcy" ...
Weegy: Washington Disarmament Conference was on 1921 and established a treaty between the United States, France, ...
2/8/2016 9:35:32 AM| 2 Answers
Weegy Stuff
S
Points 246 [Total 643] Ratings 0 Comments 246 Invitations 0 Offline
S
P
P
Points 164 [Total 971] Ratings 0 Comments 164 Invitations 0 Online
S
1
L
L
P
R
P
L
P
Points 114 [Total 11287] Ratings 0 Comments 114 Invitations 0 Online
S
L
P
Points 46 [Total 2114] Ratings 0 Comments 46 Invitations 0 Offline
S
R
Points 9 [Total 445] Ratings 0 Comments 9 Invitations 0 Offline
S
Points 5 [Total 289] Ratings 0 Comments 5 Invitations 0 Online
S
Points 4 [Total 904] Ratings 0 Comments 4 Invitations 0 Offline
S
Points 4 [Total 4] Ratings 0 Comments 4 Invitations 0 Offline
S
Points 2 [Total 2] Ratings 0 Comments 2 Invitations 0 Offline
S
Points 1 [Total 2] Ratings 0 Comments 1 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)