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

"Gord Dibben" wrote:

In commission rate column

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

In commission column

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


Gord


On Sun, 21 Oct 2007 10:15:01 -0700, CV wrote:

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 $-


"Gary''s Student" wrote:

=IF(C25=50000,.03*C25,.02*C25)
--
Gary''s Student - gsnu200750


"CV" wrote:

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