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|

Rating

There are no new answers.

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

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 have 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.
**Weegy:** Please complete your question so we can better help you. (More)

Question

Expert Answered

Asked 11/10/2012 4:22:43 PM

0 Answers/Comments

In Excel: You have 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.
**Weegy:** Please complete your question so we can better help you. (More)

Question

Expert Answered

Asked 11/10/2012 4:21:35 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

0 questions answered

There are no comments.