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

Rating

There are no new answers.

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

There are no comments.