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

Q

A statistician selected a sample of 16 accounts receivable and determined the sample standard deviation of $400....

Statistics
Q

Consider the following initial value problem to be solved by undetermined coefficients. y″ − 16y =...

Advance Math
Q

What is a possible procedure I can use to determine the direct solubility of KHT following...

Chemistry
Q

3. In ion mobility spectrometer, the ions are accelerated under a constant electric field in a...

Physics
Q

How could I create a Powe supply of aproximable 5V DC output with atleast 100mA with...

Electrical Engineering
Q

This is an introduction to social science research methods course: Imagine you’re planning to estimate the price...

Basic Math
Q

Beaumont Company enters into a contract to provide a high quality diving-certification preparation package, including goggles, snorkels,...

Accounting
Q

otplate is positio xy plane positive y direction The x 0 and x L edges...

Basic Math
Q

A boat is heading due east at 32 km/hr (relative to the water). The current...

Basic Math
Q

in preparing its cash flow statement for the year ended December 31,2016, Red Co., gathered...

Accounting
Q

La lista incluye todas las cuentas del balance relacionadas con el efectivo de las actividades...

Accounting
Q

Which of the following represents the normal sequence in which the below budgets are prepared?...

Accounting