Question: How to properly formulate an IF function in excel to give students who have spent more than $1500 on textbooks in the past year and

How to properly formulate an "IF" function in excel to give students who have spent more than $1500 on textbooks in the past year and more than $700 in the past six months 30% off?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

Q:

Briefly discuss the cost-volume-profit analysis model and how it is used. Use the attached PDF. APA Citation. 300 words. REVISED PAGES 3 Chapter Three 1 Fundamentals of Cost-Volume-Prot Analysis...

Q:

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

Q:

Do question 4 for JAN 2013 and question 3 and 4 for July 2012.This module is income tax for singapore.Do it in microsoft word. ACC213 Examination - January Semester 2013 Introduction to Income Tax...

Q:

1/ What is the problem of this case study? 2/ Provide some Assumptions. 3/ Suggest some solutions and Recommendations that we should consider in Quality Management In Supply Chain Industry. THE...

Q:

Each separate response must have approximately 200 words. Assignments vary widely; however, essays should be written in APA style, with in-text citations and a separate reference listing as...

Q:

Each separate response must have approximately 200 words. Assignments vary widely; however, essays should be written in APA style, with in-text citations and a separate reference listing as...

Q:

ATC 14-1 (Pg. 686) 1.(Follow the cash) In a narrative format, answer the questions posed in the case. 2.What is meant by "presentation of financial statement information in common-size amounts rather...

Q:

ATC 14-1 (Pg. 686) 1.(Follow the cash) In a narrative format, answer the questions posed in the case. 2.What is meant by "presentation of financial statement information in common-size amounts rather...

Q:

Each separate response must have approximately 200 words. Assignments vary widely; however, essays should be written in APA style, with in-text citations and a separate reference listing as...

Q:

Explain how a competitive, profit-maximizing firm decides how much of each factor of production to demand.

Q:

(a) Show that the mass M of an atom is given approximately by Mapp = Amp, where A is the mass number and mp the proton mass. For (b) 1H, (c) 31P, (d) 120Sn, (e) 197Au, and (f) 239Pu, use the mass...

Q:

INDEFINITE PERIODS, INCONSISTENT GROWTH $ 5 0 dividend at the beginning of year 5 This dividend grows at 5 % during years 5 and 6 After that it grows at 2 % forever

Q:

Using the Top Down Apportion Method to calculate, what is the cost of: 1. Back Brakes? 2. Gears? 3. Body

Q:

2. How should this be dealt with by the organisation?

Q:

2. Obtain a copy of an organisations discipline and grievance procedure and compare it with how we have described these processes. Identify and comment on the similarities and differences.

Q:

explain what is meant by the term fair dismissal