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 makes Excel such a valuable business tool
Weegy: We can store so many data and can add,multiply, divide, subtract the data as we wish. Important tools like formulas can be easily employed to find out analytical result. Easy and convenient to create daily / weekly / monthly records (More)
Question
Expert Answered
Asked 11/5/2012 12:51:16 PM
0 Answers/Comments
what are the different features of Excel that make it a valuable business tool.
Weegy: Features of excel that make it good for buisness are A database table is simply a collection of data that is categorized into columns and rows. Because of its grid line format, making a database table in Excel is simple. [ Enter the data into the horizontal rows, which are labeled with numbers. Use the vertical columns on the spreadsheet, which are headed with letters, to separate data. Read more: Ways to Use Microsoft Excel | eHow.com ] (More)
Question
Expert Answered
Asked 11/5/2012 1:16:04 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:20:48 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
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
27,024,154 questions answered
Popular Conversations
emotive language
Weegy: Emotive language is language that arouses the emotions, such as that used in sensational newspaper headlines. ...
2/22/2017 7:31:53 AM| 3 Answers
Solve 1 – 2x – 1 = –10. A. x = –9 B. x = 5 C. x = 9 D. No ...
Weegy: 8x + 10 = 2x - 8; 8x - 2x = -8 - 10; 6x = -18; x= -18/6; x = -3. The answer is A. x = -3
2/22/2017 9:01:03 AM| 2 Answers
What is the currency of the United ...
2/22/2017 10:41:35 AM| 2 Answers
What is the slope of a line that is perpendicular to the line whose ...
Weegy: The answer is zero. The property is identity property of addition. This property states that any number plus 0 ...
2/22/2017 1:54:56 PM| 2 Answers
Weegy Stuff
S
P
P
L
Points 418 [Total 1187] Ratings 2 Comments 398 Invitations 0 Offline
S
P
P
L
P
P
Points 333 [Total 2307] Ratings 1 Comments 323 Invitations 0 Offline
S
P
P
L
P
Points 226 [Total 1440] Ratings 0 Comments 226 Invitations 0 Offline
S
Points 30 [Total 30] Ratings 3 Comments 0 Invitations 0 Offline
S
Points 12 [Total 112] Ratings 1 Comments 2 Invitations 0 Offline
S
Points 12 [Total 22] Ratings 1 Comments 2 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 1 Comments 0 Invitations 0 Offline
S
Points 5 [Total 5] Ratings 0 Comments 5 Invitations 0 Offline
S
Points 4 [Total 4] Ratings 0 Comments 4 Invitations 0 Offline
S
Points 4 [Total 4] Ratings 0 Comments 4 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.