How do I create an IF Function in excel to calculate the commission amounts and How do I create the IF Function to calculate the bonus $-$ I have also Defined the names as follows

Sales Rep Comm Code $1$st Quarter Sales$$Commission $$ Bonus $($I have already determined the bonus for everyone$)$

Kimsey, C$.$J$.$ Code $2($commission Code$)$$$120,674($Quarter Sales #$1)$

Toven, Steve $($Code $1)$$$85,784$

Claxton, Marie $($Code $1)$$$48,943$

Post, Jackie $($Code $1)$$$80,452$

Jackson, Elizabeth $($Code $2)$$$125,739$

Millington, Jeff $($Code $1)$$$82,649$

Code $1$ Commission Rate $10\%($comm code $1)$

Code $2$ Commission Rate $12\%($comm code $2)$

Sales Level for Bonus $$$$85,000$

Bonus Commission Rate $2\%$

Logical test $=$

Value if true $=$

Value if false$=$

I am struggling with the correct way to enter this into the FX function