Adding an "IF" statement to a formula

[pjewett]

Hi All,

New to the forum so I hope I'm posting this in the right place?

I have a simple formula in an excel spreadsheet that I need to expand but I've not been able to figure out how. I'm pretty new to this and think it's probably simple.

The report I'm creating compares sales growth (year to year) by customer for our Sales Reps and determines what kind of bonus they should get for that growth. A sample of one of those lines is below.

00014 American Wholesale BookCompany TW $616,863 (2008) $684,846 (2009) 11% (growth %) $6,798.22 (bonus)

The first part of the formula is =E3/D3-1 which divides the accounts total sales for 2009 by total sales for 2008 -1 and provides the % of growth.

The second part of the formula is =IF(F3>=0.1,((E3-D3)*0.1),0) which determines 1st if the growth was greater than or equal to 10% and if so takes that growth in $ and gives the Rep a bonus of 10% of that growth.

This is what is working. However I need to add a parameter to the formula somewhere that if the value in 2008 sales is LESS than $500 in the first place than do not proceed with the rest of the calculation.

Can anyone help me with this?

[NBVC]

Welcome to the forum,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[6StringJazzer]

It appears that you have corrected your thread title so I'll give this a shot. In this particular case you don't really need to add an IF:

=IF(AND(D3>=500,F3>=0.1),((E3-D3)*0.1),0)