Need help. I'm trying to assign a commission to a particular sales rep in excel and have it tag a percentage value to an individual name. Example. I have 2 reps - Mark and David. David gets 5% commission and Mark gets 10% commission - I want to be able to put in a formula that tells excel to calculate 5% when the account name's cell says David and 10% when Mark's name is in there. Something like =IF("David'), H43*.05? Thanks for your help...
Bookmarks