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: 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 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 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
19,758,456 questions answered
Popular Conversations
How far does a boat travel in 3 hours at 65 miles per hour?
Weegy: A boat travel in 3 hours at 65 miles per hour is 195 miles far. 3 hours * 65 miles/hour = 195 miles User: ...
3/2/2015 9:48:36 AM| 6 Answers
Evaluate the following expression. (81)0 0 1 8 User: ...
Weegy: Answer : If m=2 and n= -1 To evaluate m0 - n2 is 2(0) - -1 (2) = 0 - -2 = =+2 or simply 2 User: Evaluate the ...
3/2/2015 11:47:48 AM| 6 Answers
Describe the location of the point that has the following ...
Weegy: First Quadrant. User: Find the value of 7 + 32 (-5 + 1) ÷ 2. User: What is the fractional equivalent of ...
3/2/2015 10:04:10 AM| 5 Answers
Simplify 7 · 6 · 2h · d.
Weegy: Please state your question again. The one that you have put cannot be understood by Weegy! User: Simplify 7 · ...
3/2/2015 1:02:06 PM| 5 Answers
Factor 49t 6 - 4k 8
Weegy: 49t^6 - 4k^8 = (7t^3 + 2k^4)(7t^3 - 2k^4) User: Factor -5x 2 y + 10xy - 15xy 2 Weegy: Factor completely: ...
3/2/2015 2:56:09 PM| 4 Answers
Evaluate 5x3 + 2 for x = -1.
Weegy: 5(-1)^3 + 2 = -5 + 2 = -3 . which is B User: Simplify 9 - {x - (7 + x)}. User: Simplify 6r · s · 4rt. ...
3/3/2015 12:50:12 PM| 4 Answers
The first term of a geometric sequence is 7, and the ratio ...
Weegy: The ratio is 2/1. User: What is the 6th term of the following geometric sequence? 2,-14,98,-686
3/2/2015 9:59:00 AM| 3 Answers
Simplify -(4) to the -3 power User: Simplify -6 to the 0 power ...
Weegy: 4/5^-2 = 4/(1/5^2) = 4/(1/25) = 4 * 25/1 = 100/1 = 100
3/2/2015 8:20:12 PM| 3 Answers
Simplify 7(A - 6). User: Simplify 0.05x + 1.02x. User: Simplify ...
Weegy: b(a + b) - a(a - b) = ab + b^2 - (a^2 - ab) = ab + b^2 - a^2 + ab = 2ab + b^2 - a^2 User: Simplify 10x - 3x ...
3/3/2015 10:41:26 AM| 3 Answers
Which of the following values is farthest to the left on the number ...
Weegy: The value farthest to the left on the number line is 2. User: Find the value of 21 + 4(32 - 5). Weegy: 3-3 ...
3/3/2015 12:37:15 PM| 3 Answers
What is the equation of the line that passes through (4, -1) and (-2, ...
Weegy: y = (-2/5)x - 2 User: What is the equation of the line that passes through (-3, -1) and has a slope of ? ...
3/3/2015 3:06:50 PM| 3 Answers
Weegy Stuff
S
L
P
L
P
P
P
Points 176 [Total 8062]| Ratings 0| Comments 176| Invitations 0|Offline
S
1
L
L
Points 52 [Total 7553]| Ratings 0| Comments 52| Invitations 0|Offline
S
P
C
L
P
L
1
P
Points 31 [Total 7338]| Ratings 0| Comments 31| Invitations 0|Offline
S
Points 22 [Total 390]| Ratings 0| Comments 22| Invitations 0|Online
S
Points 16 [Total 107]| Ratings 0| Comments 16| Invitations 0|Offline
S
1
Points 15 [Total 926]| Ratings 0| Comments 15| Invitations 0|Offline
S
Points 11 [Total 127]| Ratings 1| Comments 1| Invitations 0|Offline
S
Points 10 [Total 10]| Ratings 1| Comments 0| Invitations 0|Offline
S
Points 10 [Total 240]| Ratings 1| Comments 0| Invitations 0|Offline
S
1
L
Points 2 [Total 3160]| Ratings 0| Comments 2| Invitations 0|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.