I'm using excel 2007 and need help with a formula.  This is the formula that somebody created but left the company and I need to know how to recreate it:
=IF(G3>0,G3*Rates!$C$8,0)

What I need to do is
If the retention difference (G3) > 0 then multiply theretention difference if attainment was over over 95% - 100% by 3% and if over 100% multiply by 7%.

Any ideas?   I tried looking into the solver but can't figure it out
 

---

Answer from Richard Rost:

You could use a nested IF function to solve this, but for items with multiple possible values like this, I would use VLOOKUP. Here are two tutorials to help you with each:

http://www.599cd.com/tips/excel/misc/if-function-sales-tax.asp?key=BlFAlEx

http://599cd.com/tips/excel/vlookup?key=BlFAlEx