I need help with My IF Statement....

  • Thread starter Thread starter ashbyb14
  • Start date Start date
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
(e-mail address removed).

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

Thank
 
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
 
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
 
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
 
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?
 
Back
Top