I need help with My IF Statement....

A

ashbyb14

I'm a college student and we are doing an assignment. I made it all th
way to the end without any problems and now I'm stuck. The part I'
stuck on involves using an IF Statement to determine whether or not
bonus should be applied based on sales made. This will make much mor
sense once you look at my workbook. I've got everything setup I jus
need some help on where to put my numbers and formulas.

If you think you can help me, reply to this thread or email me a
[email protected].

I can email you my workbook and instructions of what I'm suppose to d.

Thank
 
G

Gord Dibben

No need for a workbook.

Just show us a small example of your data and what you want your IF formula to
do for you.

You'd be amazed at what makes sense to some of the regulars around here<g>

Gord Dibben Excel MVP
 
A

ashbyb14

Its kinda hard to explain...I've got my workbook set-up to where I
needs to be..I just need numbers and formulas put in. It would b
easier to look at that way. Thanks for any help
 
J

JulieD

Hi

can't speak for Gord here, but most people won't accept workbooks due to
download costs and the risk of viruses and as Gord said originally, we're
pretty used to understanding what people need without looking at the
workbooks.

All you need to tell us is something like, in cell D5 i have a sales figure,
in cell E5 i would like to see the bonus paid on this sales based on the
following criteria - if the sales are over $5,000 then the bonus is 10% of
the sale, if the sale is over $10,000 then the bonus is 20% or whatever.
Give it a shot - if you do manage to totally confuse us, we'll look at the
workbook :)

Cheers
JulieD
 
R

Robgrant

The best thing I can tell you about If statements is this:

IF (true) THEN do something, OTHERWISE do something else

For example:

IF C5=>$100, E5=$10, E5=0

Does that help?
 
Top