Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel+vba+training - if statement excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+vba+training - If Statement - Excel

excel+vba+training - If Statement - Excel

ResolvedVersion Standard

Dan has attended:
No courses

If Statement - Excel

Hello

I have this IF statement which should work out the commission for a customer baed on how many units they sell
Here is the breakdown of the commission factors (they get a percentage of a set fee)

0-500 35%
501-750 40%
751-1000 45%
1001+ 50%

Now i have the formula for the IF statement as follows, but it doesnt work, can you tell me where im going wrong please

=IF(E4>=1001,((B4*50%)*(E4-1001))+((B4*45%)*250))+((B4*40%)*250)+((B4*35%)*500),IF(E4>751,((B4*45%)*(E4-751))+((B4*40%)*250))+((B4*35%)*500)),IF((E4>501,(B4*40%)*(E4-501))+((B4*35%)*500)),IF(E4<500,(B4*35%)*501),0)))

Edited on Thu 8 Nov 2007, 14:42

RE: If Statement - Excel

Hi Dan:

It's a 'Brackets' problem! I've attached a workbook containing the amended function - the formula is in A10.

By the way, I haven't tested to see if the function works the way you want it to (I'll leave that to you!) - just that it works!

Regards,

Tony Gay

Attached files...

Multiple IFs.xls

Excel tip:

Quickly hide and unhide rows and columns

Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.