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
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 operations?
Weegy: Text and database (if you consider date&time to be mathematical). (More)
Question
Expert Answered
Asked 11/7/2012 12:38:51 PM
0 Answers/Comments
What are the differences between formulas and functions in Excel
Weegy: A formula is statement written by the user to be calculated. Formulas can be as simple or as complex as the user wants. [ A formula can contain values, references to cells, defined names, and functions. All formulas must start with the equals sign. =1+2+3 A function is a piece of code designed to calculate specific values and are used inside formulas. Functions to sum values, calculate a trigonometric cosine, and to calculate the current time are built into excel. Additional functions can be defined using Visual Basic. Functions are typed alongside parenthesizes, where in the arguments if any are listed in between. To use functions in a formula, for example =COS(3.14) will return the calculated cosine. =NOW() returns the current time. =SUM(1+2+3) *2 will multiply the sum by 2 .............. ] (More)
Question
Expert Answered
Asked 11/11/2012 12:15:37 PM
0 Answers/Comments
What are the differences between formulas and functions in Excel
Weegy: A function is a built in set of executable codes to perform a specific task. For example, the Sum() function will add a group of numbers within the range specified in the parenthesis. [ But what if you want to add half the numbers, then add the other half , and multiply the two sums together. There is no prebuilt function in Excel to do that. You need to write a formula. A formula is a set of commands to generate a specific result. The commands may include functions. For example, I could write a simple formula: =sum(a1:a12)*sum(b1:b12). This formula combines the Sum function with the multiplication operator to create the formula. source:yahoo ] (More)
Question
Expert Answered
Asked 11/11/2012 12:44:42 PM
0 Answers/Comments
21,972,702 questions answered
Popular Conversations
mesosphere
Weegy: Stratospher is between the troposphere and the mesosphere in earths atmosphere. User: stratosphere User: ...
9/1/2015 5:07:52 PM| 4 Answers
Article II of the Constitution is important because it ___________.
Weegy: Article II of the Constitution is important because it executive branch of the government. User: gives ...
9/1/2015 8:57:19 AM| 2 Answers
Simplify 6(x + 3). 6x + 3 6x + 18 6x + 9 x + 18
Weegy: (6x)^2 = 36x^2 User: Simplify 6(x + 3). Weegy: that's not possible! what do you need to know. [s] User: ...
9/1/2015 9:57:41 AM| 2 Answers
The term semantics is derived from the Greek word semantikos, which ...
Weegy: The term semantics is derived from the Greek word semantikos, which means the study of meaning. It is also ...
9/1/2015 9:56:48 AM| 2 Answers
Buying an existing business _____.
Weegy: hello what is your question? User: Buying an existing business _____. Weegy: hello what is your question? ...
9/1/2015 12:12:57 PM| 2 Answers
The leader of the Mensheviks was
Weegy: Vladimir Lenin led the Bolsheviks and Julius Martov led [ the Mensheviks. ] User: What did the "October ...
9/1/2015 1:23:50 PM| 2 Answers
Weegy Stuff
S
Points 34 [Total 339]| Ratings 0| Comments 34| Invitations 0|Offline
S
Points 33 [Total 817]| Ratings 0| Comments 33| Invitations 0|Offline
S
1
L
L
P
R
Points 33 [Total 9356]| Ratings 0| Comments 33| Invitations 0|Offline
S
L
L
P
1
Points 27 [Total 9337]| Ratings 1| Comments 17| Invitations 0|Offline
S
Points 13 [Total 201]| Ratings 0| Comments 13| Invitations 0|Offline
S
Points 9 [Total 233]| Ratings 0| Comments 9| Invitations 0|Offline
S
Points 6 [Total 289]| Ratings 0| Comments 6| Invitations 0|Offline
Points 0 [Total 0]| Ratings 0| Comments 0| Invitations 0|Offline
Points 0 [Total 0]| Ratings 0| Comments 0| Invitations 0|Offline
S
Points 0 [Total 0]| Ratings 0| Comments 0| Invitations 0|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2015 Purple Inc.