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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

1) Calculate either [H3O ] or [OH

Chemistry
Q

How might the study of the brain contribute to a better understanding of how we make...

Psychology
Q

In a simple random sample of 1000 people age 20 and over in a certain? country,...

Basic Math
Q

What are some of the disadvantages of aquaponic farming?

Biology
Q

In a population of wild geese there were 17 births and 62 deaths in the...

Biology
Q

63 Two particles undergoes perfecting inelastic collision as shown in the figure The final speed...

Physics
Q

50 A circuit consists of five identical conductors as shown in figure The conductors are...

Physics
Q

Starting from the transformation under diffeomorphisms for the connection coefficients Tuen Tex Te a Prove...

Basic Math
Q

Find a possible formula for the polynomials with the given properties: f is third degree...

Basic Math
Q

1. Cuando un cliente hace una recomendacin a favor (o en contra) de una marca...

Accounting
Q

Multple Cnolce $(140,000) $(144,000) $(163,000) $[143,000]

Accounting
Q

Required information [The following information applies to the questions displayed below.] The following partially completed...

Accounting