NESTED IF STATEMENTS

[budlightknight]

Having a little problem in an excel class, hoping someone might be
able to help. I'm trying to fill in the discount column on a
spreadsheet with the following info. The problem states use a nested
form of the IF function to calculate 15% if Amount is greater that
$300., 10% if Amount is greater than $100., and 0% if Amount is less
than $100. The Amount column is cell D5. Anyone know how to write the
formula and explain how to go about it? Any help would be much
appreciated.

 

[Don Guillett]

Let's see. This is homework so you should come up with the answer yourself.
Did you start by looking in the help index for IF. There are good examples
that should get you an "A".

 

[Gord Dibben]

=IF(D5>300,D5*0.15,IF(D5<100.01,D5,D5*0.1))

Not a nested IF formula but will do the job.

=LOOKUP(D5,{0,100.01,300.01},{0,0.1,0.15})*D5

Present it to your instructor and get extra points for creativity.


Gord Dibben MS Excel MVP

 

[Don Guillett]

And be very sure to tell em that Gord gave it to you.

 

[Gord Dibben]

I am positive that would happen Don<g>

Apologies for posting over your reply..........didn't see before replying.

Sometimes I take it too easy on the ones with class assignments.

Teach a man to fish might be a better solution as you point out.


Gord

 

[budlightknight]

I am positive that would happen Don<g>

Apologies for posting over your reply..........didn't see before replying..

Sometimes I take it too easy on the ones with class assignments.

Teach a man to fish might be a better solution as you point out.

Gord



- Show quoted text -

I'm not looking to get an "A". I was just looking for some help on
learning how to figure it out and I did email the teacher and let him
know I was looking for help on the internet. But I did finally figure
out an IF statement on my own. Gord, thanks for trying to help. Don,
I'm not a cheater, I was just stuck and looking for help. And yes I
did look on the insert function for help but I was still confused.
After emailing the teacher twice without a reply I went to the
internet for help, and your comments are making wish I hadn't.

 

[Don Guillett]

I didn't mean to infer you were a cheater. You said that. I did refer you to
the help index for IF because it is much more meaningful, as Gord said, that
you learn how to fish instead of being tossed fish. It does give a good
example of a nested if.

Formula Description (Result)
=IF(A2>89,"A",IF(A2>79,"B", IF(A2>69,"C",IF(A2>59,"D","F")))) Assigns
a letter grade to the first score (F)
=IF(A3>89,"A",IF(A3>79,"B", IF(A3>69,"C",IF(A3>59,"D","F")))) Assigns
a letter grade to the second score (A)
=IF(A4>89,"A",IF(A4>79,"B", IF(A4>69,"C",IF(A4>59,"D","F")))) Assigns
a letter grade to the third score (C)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

I am positive that would happen Don<g>

Apologies for posting over your reply..........didn't see before replying.

Sometimes I take it too easy on the ones with class assignments.

Teach a man to fish might be a better solution as you point out.

Gord



- Show quoted text -

I'm not looking to get an "A". I was just looking for some help on
learning how to figure it out and I did email the teacher and let him
know I was looking for help on the internet. But I did finally figure
out an IF statement on my own. Gord, thanks for trying to help. Don,
I'm not a cheater, I was just stuck and looking for help. And yes I
did look on the insert function for help but I was still confused.
After emailing the teacher twice without a reply I went to the
internet for help, and your comments are making wish I hadn't.