Microsoft Office Forums - View Single Post - [Solved] What formula should I use to calculate commission?

Thread: [Solved] What formula should I use to calculate commission?

View Single Post

Old

02-20-2011, 03:42 PM

Kimberly

Kimberly is offline

Kimberly uses Windows 7

Windows 7

Kimberly uses Office 2010 (Version 14.0)

Office 2010 (Version 14.0)

Expert

Join Date: May 2010

Posts: 517

Kimberly is on a distinguished road

Default

Put .015 in cell D1
Put .0075 in E1

=IF(A1<=25000,A1*$D$1,25000*$D$1+(A1-25000)*$E$1)

Reply With Quote