Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

If a salesperson sells $60,00.00 or more they get 3.5% commission, and if

they sell less than $60,000 they get a 2.5% commission.

How would I write that formula for a column of figures?

Hope this will work

=IF(A1>=60000,A1*0.35,IF(A1<60000,A1*0.25))

This is not correct IMO. Norma needs to work on this herself in order to

learn, not have the answer provided.

This looks like an assignment you have been set to develop your ability. If

we tell you the answer you will learn nothing.

You know that the If statement has three parts

The first part is the condition. In this case the condition is that total

sales are greater than a certain figure.

The next part is what you want if the condition is true i.e. the formula for

the commission on the higher sales amount.

The third part is what you want if the condition is not true i.e. the formula

for the commission on the lower sales amount.

The format is

If(first part, second part, third part)

Now, You have a go at it and see if it works, then come back to the group with

what you have done if you have any problems. We can then explain the parts

you don't understand.

By the way, Norma, Don't worry about getting the formula right for a column of

figures until you have it right for one figure.

I think what is stumping me is the value. Am I suppose to make up one or am

I missing something.?

Not sure I know what you mean. But, in order to test the formula, you will

need example values. If these haven't been provided to you, you will need

to create them for yourself.

Now why couldn't the instruction say that?

Excel is new to me and I need to follow every little detail.

I am an old dog learning new tricks.

As an aside to the main point, that old saying that you can't teach

old dogs new tricks is not true for either humans or dogs. My dad

trained sheep dogs for many years, and they learned right up until

the day they died . . . if you're interested, I can explain the

confusion about that in reference to people in the research

about "learning" since the 70's.

Let me know, and I'll be happy to fill that in.

Didn't find what you were looking for?
Find more on formula
Or get search suggestion and latest updates.

Related Topics:

- clearing cells value without deleting the formula I've made in cell from excel formula , HOW?
- Disabling Formulas, Not calculation
- Blank Formula bar
- Manually creating a row outline with no formula anywhere
- sum formula
- cells containing formula that refer to user-defined VBA function
- Named formula/Windows dialog boxes
- Stuck on copying formula from 1 sheet to another
- Ctrl+Shift+Arrow Fails To Select Cells When Used in Formula Bar
- Array Formula
- Copy down formula with vba
- Loop in formula
- formula help but not vba please
- How to add several conditions for formula "SUMIF"
- combining formula
- VBA code to add values in two cells which have formulas
- VBA or array formula?
- Paste Formula help
- R1C1 Formula
- Three Leveled Formula
- Formula using range name in VBA code
- searching within formulas
- Populate Formula(Function) in rows
- Getting a formula to copy from inside VBA
- VBA Formula prob