Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. you'll be using the if function in this one... her

You'll be using the IF function in this one... here's the problem: You have a...

60.1K

Verified Solution

Question

Accounting

You'll be using the IF function in this one... here's the problem: 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. You are to display "YES" or "NO" based on an IF function that looks at the date and decides if it meets the criteria in the comment box. How do you write the IF function formula for each in Excel?

Today's date: 7/16/2019
Name Date Contract Signed Annual Expiration Date Time to Renew?
Benton Electrical Supply 4/7/2019 4/6/2020
Calvin City Motors 8/10/2018 8/10/2019
Universal Suppliers 9/19/2018 9/19/2019
Service is First 5/27/2019 5/26/2020
Mini Maids 1/7/2019 1/7/2020
Westwood Medical 7/31/2018 7/31/2019
Alphabet Movers 12/8/2018 12/8/2019
Genuine Hat Makers 1/7/2019 1/7/2020
Superier Roofers 3/23/2019 3/22/2020
Gemini Beauty Supply 7/26/2018 7/26/2019
Crossroads Ministries 12/28/2018 12/28/2019

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Operations Management
1.2K views

Should the intelligence elements of Customs and Border Protection and Immigration and Customs Enforcement become part...

Physics
1.2K views

Q 5 In a usual Young s double slit experiment with 5000 d 2 m...

Physics
1.2K views

The resistance thermometer of the wire in the platinum resistance at ice point is 5...

Statistics
1.2K views

B Points Monday through Thursday when there isn t a holiday the average number of...

Statistics
1.2K views

A presidential candidate plans to begin her campaign by visiting the capitals in 4 of...

Algebra
1.2K views

Find all the critical numbers of f x x 3x 1 then determine the local...

Algebra
1.2K views

Which vertex listed below could be described as a TRANSMITTER OV O Question 29 2...

Accounting
1.2K views

On December 1, 2021, your company borrowed $31,500, a portion of which is to...

Accounting
1.2K views

Describe what a Job-Order Cost System is for a manufacturing business. Include in...

Accounting
1.2K views

On January 6, Year 1, Mount Jackson Corporation purchased a tract of land...

Accounting
1.2K views

Hello Expert, Could you please solve for me the trail balance, balance sheet, T accounts...

Accounting
1.2K views

Discuss the effects of all five major accounting assumptions on the accounting process.