Looking for help with a formula

[bverrett]

I currently have a spreadsheet that figures commissions based on one of two factors.

1. Mono-line commissions
2. Multi-line commissions

I want to add, if possible, a way to divide the commission by 2 if it is a shared commission.

This is the formula that I am using.

=IF(F5="NO",VLOOKUP(C5,monolinecommission,2,FALSE)*D5,IF(F5="YES",VLOOKUP(C5,HHBundlecommission,2,FALSE))*D5)

Cell D5 is the premium, F5 is where we choose if it is multi-line (yes or no option), G5 is where the above formula is to figure the commissions, H7 is where we choose if the commissions are split with someone else (dropdown list).

I am new at this (posting in forums & building formulas) so let me know if more information is needed.

 

[jarjarbingie]

I currently have a spreadsheet that figures commissions based on one of two factors.

1. Mono-line commissions
2. Multi-line commissions

I want to add, if possible, a way to divide the commission by 2 if it is a shared commission.

This is the formula that I am using.

=IF(F5="NO",VLOOKUP(C5,monolinecommission,2,FALSE)*D5,IF(F5="YES",VLOOKUP(C5,HHBundlecommission,2,FALSE))*D5)

Cell D5 is the premium, F5 is where we choose if it is multi-line (yes or no option), G5 is where the above formula is to figure the commissions, H7 is where we choose if the commissions are split with someone else (dropdown list).

I am new at this (posting in forums & building formulas) so let me know if more information is needed.

assuming H7 is left blank if the commission would not be split:

G5=(IF(F5="NO",VLOOKUP(C5,monolinecommission,2,FALSE),VLOOKUP(C5,HHBundlecommission,2,FALSE))*D5)/IF(H7="",1,2)

 

[bverrett]

Thank you, I was getting an error still, so instead of using /IF(H7='',1,2) I used /(IF(H5="",1,2)) it worked perfect!