calculate an agent's split based on certain criteria.

1. calculate an agent's split based on certain criteria.

Hello everyone.

I'm in need of a formula for my Real Estate Office. The purpose of this formula would be to calculate an agent's split based on certain criteria.

For example...

John has a 75/25 split
Maria has a 60/40 split

John brings in a \$20,550 commission
Maria brings in a \$10,420 commission

I'm basically looking for a formula (based on the person's name) that when Maria brings in a commission, apply 60% and if John brings it in, apply 75%. See attachment for reference.

2. Re: Need Formula for Real Estate

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

3. Re: Need Formula for Real Estate

Thanks for the quick reply, Alan.

The gray column is what I'm trying to automate. Based on the initials put in column H, I'm trying to automatically populate column E, thus automatically calculating the rest of the spreadsheet. Let me know if that doesn't make sense.

4. Re: calculate an agent's split based on certain criteria.

permo, I have edited your title to be more representative of what your question/problem is. Im sure you would agree that if you saw a question like "Need Formula for Real Estate" and you have no idea what it was about, the title alone would not give any clue as to what was required.

Thanks

5. Originally Posted by FDibbins
permo, I have edited your title to be more representative of what your question/problem is. Im sure you would agree that if you saw a question like "Need Formula for Real Estate" and you have no idea what it was about, the title alone would not give any clue as to what was required.

Thanks
Understood. Thanks for editing the title 👍🏼

6. Re: calculate an agent's split based on certain criteria.

In Cell E6 =VLOOKUP(H6,\$J\$19:\$L\$22,3,0)*C6

7. Re: calculate an agent's split based on certain criteria.

you are incredible. thank you

I changed the formula to =VLOOKUP(\$H6,\$J\$19:\$L\$33,3,0)*\$C6 so I can be able to drag it down the column. works great but now there's another issue...

Being that column E is a Vlookup, it does not calculate the values in my Summation cells (E22, E33, E39) and is throwing off automated calculation in other cells. any advise?

Updated Excel with your formula attached...

8. Re: calculate an agent's split based on certain criteria.

wrap your formula in an iferror function that makes the value a zero instead of #NA

=IFERROR(VLOOKUP(\$H6,\$J\$19:\$L\$33,3,0)*\$C6,0)

9. Re: calculate an agent's split based on certain criteria.

you're incredible, Alan. really appreciate your help

the formula is perfect. it's exactly what i needed

10. Re: calculate an agent's split based on certain criteria.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

11. Re: calculate an agent's split based on certain criteria.

will do. thanks again

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1