Jeffmonster
New Member
- Joined
- Apr 7, 2015
- Messages
- 25
Hi Everyone,
I'm seeking advice on what I believe is conditional formatting.
My spread sheet is used to track sales volume for a real estate team. The information I am looking to seek is this:
I have multiple Lead Sources we categorize our leads. 2 of the many leads are subject to a different rate (5%, rather than the usual 10%)
Under that category "Lead Source", I am trying to attach a "rate" at Which the payout amount will automatically reflect the rate according to the source.
For Example: The Two sources; "Radio-KLBJ" and "Listing Inquiry" Would both be compensated at a Rate of 5% of the total commision of the sales price where as an EX/W Outbound is 10%, If that makes sense.
<colgroup><col style="width: 345px"><col width="82"><col width="70"><col width="104"><col width="49"><col width="52"><col width="59"><col width="92"><col width="85"><col width="79"></colgroup><tbody>
</tbody>
Thanks for the looks, consideration and the help.
Jeffmonster
I'm seeking advice on what I believe is conditional formatting.
My spread sheet is used to track sales volume for a real estate team. The information I am looking to seek is this:
I have multiple Lead Sources we categorize our leads. 2 of the many leads are subject to a different rate (5%, rather than the usual 10%)
Under that category "Lead Source", I am trying to attach a "rate" at Which the payout amount will automatically reflect the rate according to the source.
For Example: The Two sources; "Radio-KLBJ" and "Listing Inquiry" Would both be compensated at a Rate of 5% of the total commision of the sales price where as an EX/W Outbound is 10%, If that makes sense.
LISTING INQUIRY - CALL/INTERNET/ETC - (BM) 203 | $200,000.00 | $6,000.00 | $300.00 | ||||||
EX/W - OUTBOUND - (LM) 402 | $200,000.00 | $6,000.00 | $900.00 | ||||||
RADIO - KLBJ - (LM) 301 | $200,000.00 | $6,000.00 | $300.00 |
<colgroup><col style="width: 345px"><col width="82"><col width="70"><col width="104"><col width="49"><col width="52"><col width="59"><col width="92"><col width="85"><col width="79"></colgroup><tbody>
</tbody>
Thanks for the looks, consideration and the help.
Jeffmonster