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
what are the different features of Excel that make it a valuable business tool.
Weegy: Ways that make excel valuable are Spreadsheets make it easy to collect and present many types of data and especially numerical information. Making a spreadsheet is similar to making a database table. [ Columns and rows should be headed to describe what is in the spreadsheet, and data should be entered accordingly. Read more: Ways to Use Microsoft Excel | eHow.com ] (More)
Question
Expert Answered
Asked 11/5/2012 1:23:38 PM
0 Answers/Comments
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
Are there any other types of non mathematical-function categories in Excel?
Weegy: Text and database (if you consider date&time to be mathematical). (More)
Question
Expert Answered
Asked 11/7/2012 12:41:47 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
25,773,153 questions answered
Popular Conversations
Plants cannot grow without ...
7/23/2016 12:28:58 AM| 2 Answers
The Taiping Rebellion was centered in: A. Mongolia. B. Manchuria. ...
Weegy: The answer is letter A. All foreigners were expelled from China.
7/23/2016 3:58:56 PM| 2 Answers
Where is carbon taken in by plants during photosynthesis stored?
Weegy: Photosynthesis is a process in which green plants use energy from the sun to transform water, carbon dioxide, ...
7/24/2016 5:39:13 AM| 2 Answers
What is the major irony in the poem “Ballad of Birmingham” by Dudley ...
Weegy: Fighting for freedom has consequences. [ is the theme of Ballad of Birmingham? by Dudley Randall ...
7/24/2016 8:13:44 AM| 2 Answers
Most plants grow in the A horizon.
7/23/2016 12:27:31 AM| 1 Answers
Weegy Stuff
S
P
L
Points 509 [Total 1259] Ratings 1 Comments 499 Invitations 0 Offline
S
Points 192 [Total 613] Ratings 1 Comments 182 Invitations 0 Offline
S
P
Points 188 [Total 447] Ratings 1 Comments 178 Invitations 0 Offline
S
L
P
P
P
Points 159 [Total 2907] Ratings 0 Comments 159 Invitations 0 Offline
S
Points 88 [Total 227] Ratings 0 Comments 88 Invitations 0 Offline
S
L
P
P
P
Points 55 [Total 3759] Ratings 0 Comments 55 Invitations 0 Offline
S
Points 11 [Total 61] Ratings 1 Comments 1 Invitations 0 Offline
S
1
L
L
P
R
P
L
P
P
R
Points 8 [Total 12606] Ratings 0 Comments 8 Invitations 0 Offline
S
L
Points 3 [Total 1766] Ratings 0 Comments 3 Invitations 0 Offline
S
Points 2 [Total 2] Ratings 0 Comments 2 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.