if statement confusion

[Guest]

Hello all,

I'm struggling with IF statements. I have an example of a IF statement I'm
trying to write. Any help would be great

EX- sales amount exceeds $50,000 and the commision equals 3%, if less than
$50,000 commision would equal 2%.

=IF(C25>=50000,"*3%",2%) I need the commision rate and actual commision.
Right now all I get is the 3% commision rate.

2nd- Ex- If my grade is 88% or better my parents will give me $100 otherwise
they will take me to dinner. Create an IF Function In cell D51

=IF(C50>=88%,"$100","take me to dinner") My questions is when would it
display "take me to dinner" vs "$100" currently the cell is showing $100.

Thanks for the help

 

[Guest]

=IF(C25>=50000,.03*C25,.02*C25)

 

[Gord Dibben]

=IF(C25>=50000,C25*3%,C25*2%)

Your second example should return "take me to dinner" if C50 is formatted to %
and is less than 88%


Gord Dibben MS Excel MVP

 

[Guest]

Ok thank for the response. So the below statement states shows how much
commission the sales person will earn. How do you create the IF function to
state the actual commission rate. I included the below to show the
formatting. I assume the first part of the statement will populate the
commission rate field and the second will populate the amount

Commission rate Commission
Baker $55,600 $-

 

[Gord Dibben]

In commission rate column

=IF(C25>=50000,"3%","2%")

In commission column

=IF(C25>=50000,.03*C25,.02*C25)


Gord

 

[Ragdyer]

Are you allowed to garner this type of assistance when completing your
homework?<g>

 

[Guest]

Thanks, that makes perfect sense! I thought that I could write a IF statement
that did it all. Really appreciate the help.

 

[Guest]

I do not see why not. I'm still doing the work, just asking for help
understanding some of the steps. If I was in class I could ask the help of
the teacher directly and get a similar explaination, or if this was a work
task I could ask for help form a co-worker, or go to the lab.

 

[Ragdyer]

So ... the title of your course is:
"How To Find Help"
???<bg>

 

[Guest]

Hmm...I find it interesting that you are taking so much interest in my
questions. This is an online community where people can ask for help. If you
look at the original example that was posted I also posted how I thought the
IF statement worked and asked questions after getting responses. I'm trying
to learn something new not just be lazy! You are being ridiculous and I do
not appreciate having my time wasted. I would also assume that you never ask
for help as apparently you find it wrong

 

[Ragdyer]

I'm not looking to waste your time, so you don't have to bother to respond.

Of course, no one knows "everything"!
Everyone, at one time or another, will find it necessary to seek help.

However, within the implication of "taking a course" and "homework", there
exists the connotation of *LEARNING*.

In the REAL world of business, accuracy AND productivity exist hand-in-hand.
Knowledge of a discipline contributes to both of these attributes.

An IT department or a consulting firm that takes twice as long as expected
to complete a project because they had to look up every aspect of the
design, cannot look forward, with confidence, to increased salaries or being
awarded additional contracts.

The more you LEARN now, the less likely that you'll fall into those failing
categories.

Even in these groups, when you see suggestions posted in lower or proper
case, you know that the respondents are so sure of their subject matter,
that testing it in XL becomes unnecessary... and that is the prime example
of accuracy AND productivity.