Conditional Formatting - varying rates linked to varying Lead Sources

J

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>
[TD="align: center"]LISTING INQUIRY - CALL/INTERNET/ETC - (BM) 203



[/TD]
[TD="align: center"]




[/TD]
[TD="align: center"]




[/TD]

[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]$200,000.00[/TD]
[TD="align: center"]$6,000.00[/TD]
[TD="align: center"]$300.00[/TD]

[TD="align: center"]EX/W - OUTBOUND - (LM) 402



[/TD]
[TD="align: center"]




[/TD]
[TD="align: center"]

[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]$200,000.00[/TD]
[TD="align: center"]$6,000.00[/TD]
[TD="align: center"]$900.00[/TD]

[TD="align: center"]RADIO - KLBJ - (LM) 301



[/TD]
[TD="align: center"]




[/TD]
[TD="align: center"]


[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]$200,000.00[/TD]
[TD="align: center"]$6,000.00[/TD]
[TD="align: center"]$300.00[/TD]

</tbody>

Thanks for the looks, consideration and the help.
Jeffmonster
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Sort by date Sort by votes
is it only the one that is at 10%

=IF( cell with name in = "EX/W Outbound" , cell with value * 0.1 , cell with value * 0.5)
what is the (LM) 402 - does that change

if would help
if you could use a file share site like dropbox or onedrive to put a sample of your workbook, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.
 
Upvote 0

<colgroup><col style="width: 81px"><col width="345"><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>
[TD="bgcolor: #3C78D8, align: center"]Company or Agent Generated[/TD]
[TD="bgcolor: #3C78D8, align: center"]Lead Source[/TD]
[TD="bgcolor: #3C78D8, align: center"]Pre List Package (Y/N)[/TD]
[TD="bgcolor: #3C78D8, align: center"]Listing Agent[/TD]
[TD="bgcolor: #3C78D8, align: center"]List Price $[/TD]
[TD="bgcolor: #3C78D8, align: center"]Comm %[/TD]
[TD="bgcolor: #3C78D8, align: center"]Live Date[/TD]
[TD="bgcolor: #3C78D8, align: center"]Close Date[/TD]
[TD="bgcolor: #3C78D8, align: center"]Sold Price[/TD]
[TD="bgcolor: #3C78D8, align: center"]Commission[/TD]
[TD="bgcolor: #3C78D8, align: center"]ISA Commission[/TD]

[TD="bgcolor: #e69138, align: center"]Agent



[/TD]
[TD="bgcolor: #e69138, align: center"]EX/W - OUTBOUND - (LM) 402



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Butch



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Company



[/TD]
[TD="bgcolor: #e69138, align: center"]LISTING INQUIRY - CALL/INTERNET/ETC - (BM) 203



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Butch



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Agent



[/TD]
[TD="bgcolor: #e69138, align: center"]FSBO - OUTBOUND - (LM) 404



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Eric



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Company



[/TD]
[TD="bgcolor: #e69138, align: center"]LISTING INQUIRY - CALL/INTERNET/ETC - (BM) 203



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Eric



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Agent



[/TD]
[TD="bgcolor: #e69138, align: center"]FSBO - OUTBOUND - (LM) 404



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]David



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Agent



[/TD]
[TD="bgcolor: #e69138, align: center"]EX/W - OUTBOUND - (LM) 402



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Eric



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Agent



[/TD]
[TD="bgcolor: #e69138, align: center"]JL/JS CALL - CIRCLE - (LM) 405



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Butch



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Company



[/TD]
[TD="bgcolor: #e69138, align: center"]RADIO - KLBJ - (LM) 301



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Butch



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Company



[/TD]
[TD="bgcolor: #e69138, align: center"]RADIO - KLBJ - (LM) 301



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Eric



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Agent



[/TD]
[TD="bgcolor: #e69138, align: center"]EX/W - OUTBOUND - (LM) 402



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Butch



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Company



[/TD]
[TD="bgcolor: #e69138, align: center"]BUYER INTERNET - KUNVERSION - (BM) 105



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Beth



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Company



[/TD]
[TD="bgcolor: #e69138, align: center"]RADIO - KLBJ - (LM) 301



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Eric



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Company



[/TD]
[TD="bgcolor: #e69138, align: center"]RADIO - KLBJ - (LM) 301



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Kim



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Company



[/TD]
[TD="bgcolor: #e69138, align: center"]RADIO - KLBJ - (LM) 301



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Butch



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Agent



[/TD]
[TD="bgcolor: #e69138, align: center"]EX/W - OUTBOUND - (LM) 402



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Eric



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Agent



[/TD]
[TD="bgcolor: #e69138, align: center"]BUYER INTERNET - REW - (BM) 101



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Butch



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Agent



[/TD]
[TD="bgcolor: #e69138, align: center"]BUYER INTERNET - REW - (BM) 101



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Butch



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Agent



[/TD]
[TD="bgcolor: #e69138, align: center"]EX/W - OUTBOUND - (LM) 402



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Eric



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Company



[/TD]
[TD="bgcolor: #e69138, align: center"]RADIO - KLBJ - (LM) 301



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Butch



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Agent



[/TD]
[TD="bgcolor: #e69138, align: center"]BUYER INTERNET - REW - (BM) 101



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Huck



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Company



[/TD]
[TD="bgcolor: #e69138, align: center"]YARD MARKETING - LISTING SIGN - (BM) 202



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Dan



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Company



[/TD]
[TD="bgcolor: #e69138, align: center"]BUYER INTERNET - REW - (BM) 101



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Huck



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Company



[/TD]
[TD="bgcolor: #e69138, align: center"]BUYER INTERNET - REW - (BM) 101



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Huck



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Agent



[/TD]
[TD="bgcolor: #e69138, align: center"]REFERRAL - DIRECTLY TO AGENT - (RM) 802



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Eric



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Agent



[/TD]
[TD="bgcolor: #e69138, align: center"]REFERRAL - DIRECTLY TO AGENT - (RM) 802



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Eric



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Agent



[/TD]
[TD="bgcolor: #e69138, align: center"]REFERRAL - DIRECTLY TO AGENT - (RM) 802



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Butch



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Agent



[/TD]
[TD="bgcolor: #e69138, align: center"]REFERRAL - DIRECTLY TO AGENT - (RM) 802



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Eric



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Agent



[/TD]
[TD="bgcolor: #e69138, align: center"]BUYER INTERNET - KUNVERSION - (BM) 105



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Beth



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Agent



[/TD]
[TD="bgcolor: #e69138, align: center"]REFERRAL - DIRECTLY TO AGENT - (RM) 802



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Eric



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Agent



[/TD]
[TD="bgcolor: #e69138, align: center"]REFERRAL - DIRECTLY TO AGENT - (RM) 802



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Eric



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #e69138, align: center"]Agent



[/TD]
[TD="bgcolor: #e69138, align: center"]REFERRAL - DIRECTLY TO AGENT - (RM) 802



[/TD]
[TD="bgcolor: #e69138, align: center"]No



[/TD]
[TD="bgcolor: #e69138, align: center"]Eric



[/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138"][/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]
[TD="bgcolor: #e69138, align: center"]$0.00[/TD]

[TD="bgcolor: #b4a7d6, align: center"]Company



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]YARD MARKETING - LISTING SIGN - (BM) 202



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]No



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]Jeff



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$468,000.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]4.50%[/TD]
[TD="bgcolor: #b4a7d6, align: center"]13-Feb[/TD]
[TD="bgcolor: #b4a7d6, align: center"]10-Apr[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$468,000.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$21,060.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$4,680.00[/TD]

[TD="bgcolor: #b4a7d6, align: center"]Agent



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]REFERRAL - DIRECTLY TO AGENT - (RM) 802



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]No



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]Eric



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$174,900.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]1.00%[/TD]
[TD="bgcolor: #b4a7d6, align: center"]27-Feb[/TD]
[TD="bgcolor: #b4a7d6, align: center"]10-Apr[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$174,900.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$1,749.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$262.35[/TD]

[TD="bgcolor: #b4a7d6, align: center"]Agent



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]BUYER INTERNET - CRAIGSLIST - (BM) 109



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]No



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]Jeff



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$232,500.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]3.00%[/TD]
[TD="bgcolor: #b4a7d6, align: center"]1/8/2015[/TD]
[TD="bgcolor: #b4a7d6, align: center"]1/8/2015[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$232,500.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$6,975.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$3,487.50[/TD]

[TD="bgcolor: #b4a7d6, align: center"]Agent



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]EX/W - OUTBOUND - (LM) 402



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]No



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]Jeff



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$225,000.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]3.00%[/TD]
[TD="bgcolor: #b4a7d6, align: center"]24-Jan[/TD]
[TD="bgcolor: #b4a7d6, align: center"]13-Mar[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$225,000.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$6,750.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$1,012.50[/TD]

[TD="bgcolor: #b4a7d6, align: center"]Agent



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]EX/W - OUTBOUND - (LM) 402



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]No



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]Eric



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$188,000.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]3.00%[/TD]
[TD="bgcolor: #b4a7d6, align: center"]25-Jan[/TD]
[TD="bgcolor: #b4a7d6, align: center"]10-Apr[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$188,000.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$5,640.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$846.00[/TD]

[TD="bgcolor: #b4a7d6, align: center"]Agent



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]FSBO - OUTBOUND - (LM) 404



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]No



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]Jeff



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$150,000.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]2.50%[/TD]
[TD="bgcolor: #b4a7d6, align: center"]23-Jan[/TD]
[TD="bgcolor: #b4a7d6, align: center"]4-Mar[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$150,000.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$3,750.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$450.00[/TD]

[TD="bgcolor: #b4a7d6, align: center"]Agent



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]EX/W - OUTBOUND - (LM) 402



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]No



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]Eric



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$94,000.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]1.00%[/TD]
[TD="bgcolor: #b4a7d6, align: center"]9-Mar[/TD]
[TD="bgcolor: #b4a7d6, align: center"]20-Mar[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$94,000.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$940.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$141.00[/TD]

[TD="bgcolor: #b4a7d6, align: center"]Agent



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]FSBO - OUTBOUND - (LM) 404



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]No



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]Jeff



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$138,750.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]2.50%[/TD]
[TD="bgcolor: #b4a7d6, align: center"]23-Feb[/TD]
[TD="bgcolor: #b4a7d6, align: center"]1-Apr[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$138,750.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$3,468.75[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$423.75[/TD]

[TD="bgcolor: #b4a7d6, align: center"]Agent



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]FSBO - OUTBOUND - (LM) 404



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]No



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]Jeff



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$203,500.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]3.00%[/TD]
[TD="bgcolor: #b4a7d6, align: center"]6-Mar[/TD]
[TD="bgcolor: #b4a7d6, align: center"]21-Apr[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$203,500.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$6,105.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$915.75[/TD]

[TD="bgcolor: #b4a7d6, align: center"]Agent



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]EX/W - OUTBOUND - (LM) 402



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]No



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]Eric



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$565,000.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]3.00%[/TD]
[TD="bgcolor: #b4a7d6, align: center"]13-Feb[/TD]
[TD="bgcolor: #b4a7d6, align: center"]13-Mar[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$565,000.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$16,950.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$2,542.50[/TD]

[TD="bgcolor: #b4a7d6, align: center"]Agent



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]BUYER INTERNET - CRAIGSLIST - (BM) 109



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]No



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]Jeff



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$182,000.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]3.00%[/TD]
[TD="bgcolor: #b4a7d6, align: center"]12-Nov[/TD]
[TD="bgcolor: #b4a7d6, align: center"]2-Mar[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$182,000.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$5,460.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$2,475.00[/TD]

[TD="bgcolor: #b4a7d6, align: center"]Agent



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]REFERRAL - DIRECTLY TO AGENT - (RM) 802



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]No



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]Jeff



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$156,740.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]3.00%[/TD]
[TD="bgcolor: #b4a7d6, align: center"]26-Sep[/TD]
[TD="bgcolor: #b4a7d6, align: center"]20-Mar[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$156,740.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$4,702.20[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$2,351.10[/TD]

[TD="bgcolor: #b4a7d6, align: center"]Agent



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]JL/JS CALL - CIRCLE - (LM) 405



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]No



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]Shawn



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$285,000.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]3.00%[/TD]
[TD="bgcolor: #b4a7d6, align: center"]10-Jan[/TD]
[TD="bgcolor: #b4a7d6, align: center"]2-Mar[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$285,000.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$8,550.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$1,095.00[/TD]

[TD="bgcolor: #b4a7d6, align: center"]Agent



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]EX/W - OUTBOUND - (LM) 402



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]No



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]Jeff



[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$557,000.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]4.00%[/TD]
[TD="bgcolor: #b4a7d6, align: center"]22-Aug[/TD]
[TD="bgcolor: #b4a7d6, align: center"]30-Jan[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$557,000.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$22,280.00[/TD]
[TD="bgcolor: #b4a7d6, align: center"]$3,342.00[/TD]

[TD="bgcolor: #ffe599, align: center"]Company



[/TD]
[TD="bgcolor: #ffe599, align: center"]RADIO - KLBJ - (LM) 301



[/TD]
[TD="bgcolor: #ffe599, align: center"]No



[/TD]
[TD="bgcolor: #ffe599, align: center"]Eric



[/TD]
[TD="bgcolor: #ffe599, align: center"]$285,000.00[/TD]
[TD="bgcolor: #ffe599, align: center"]3.00%[/TD]
[TD="bgcolor: #ffe599, align: center"]17-Apr[/TD]
[TD="bgcolor: #ffe599, align: center"]30-Jun[/TD]
[TD="bgcolor: #ffe599, align: center"]$295,000.00[/TD]
[TD="bgcolor: #ffe599, align: center"]$8,850.00[/TD]
[TD="bgcolor: #ffe599, align: center"]$442.50[/TD]

[TD="bgcolor: #ffe599, align: center"]Agent



[/TD]
[TD="bgcolor: #ffe599, align: center"]BUYER INTERNET - REW - (BM) 101



[/TD]
[TD="bgcolor: #ffe599, align: center"]No



[/TD]
[TD="bgcolor: #ffe599, align: center"]Butch



[/TD]
[TD="bgcolor: #ffe599, align: center"]$66,000.00[/TD]
[TD="bgcolor: #ffe599, align: center"]3.00%[/TD]
[TD="bgcolor: #ffe599, align: center"]22-May[/TD]
[TD="bgcolor: #ffe599, align: center"]26-Jun[/TD]
[TD="bgcolor: #ffe599, align: center"]$66,000.00[/TD]
[TD="bgcolor: #ffe599, align: center"]$1,980.00[/TD]
[TD="bgcolor: #ffe599, align: center"]$297.00[/TD]

[TD="bgcolor: #ffe599, align: center"]Company



[/TD]
[TD="bgcolor: #ffe599, align: center"]LISTING INQUIRY - CALL/INTERNET/ETC - (BM) 203



[/TD]
[TD="bgcolor: #ffe599, align: center"]No



[/TD]
[TD="bgcolor: #ffe599, align: center"]Eric



[/TD]
[TD="bgcolor: #ffe599, align: center"]$169,900.00[/TD]
[TD="bgcolor: #ffe599, align: center"]3.00%[/TD]
[TD="bgcolor: #ffe599, align: center"]20-Mar[/TD]
[TD="bgcolor: #ffe599, align: center"]22-Jun[/TD]
[TD="bgcolor: #ffe599, align: center"]$169,900.00[/TD]
[TD="bgcolor: #ffe599, align: center"]$5,097.00[/TD]
[TD="bgcolor: #ffe599, align: center"]$254.85[/TD]

[TD="bgcolor: #ffe599, align: center"]Agent



[/TD]
[TD="bgcolor: #ffe599, align: center"]EX/W - OUTBOUND - (LM) 402



[/TD]
[TD="bgcolor: #ffe599, align: center"]No



[/TD]
[TD="bgcolor: #ffe599, align: center"]Jeff



[/TD]
[TD="bgcolor: #ffe599, align: center"]$607,000.00[/TD]
[TD="bgcolor: #ffe599, align: center"]3.00%[/TD]
[TD="bgcolor: #ffe599, align: center"]6-Mar[/TD]
[TD="bgcolor: #ffe599, align: center"]29-Jun[/TD]
[TD="bgcolor: #ffe599, align: center"]$607,000.00[/TD]
[TD="bgcolor: #ffe599, align: center"]$18,210.00[/TD]
[TD="bgcolor: #ffe599, align: center"]$2,731.50[/TD]

</tbody>


Would this work?
So, it doesn't show here, but I did Data Validation for the "Lead Source" so one may only select from the items provided from that list. Your advice may work, I haven't tried it yet, but I'm just not proficient yet with If/Then formulas.
 
Upvote 0
oh and LM 402 isn't anything other than a reference for my boss I think. Code sources he may use, not sure. but those numbers all correlate to something different, yes!
 
Upvote 0
i'm not sure i understand what you are trying to do now
 
Upvote 0
Ok
I've figured some of this out so far...
This is where I am at:
=IF(J10="RADIO - KLBJ - (LM) 301",R10*0.05,R10*0.1)
I've got my formula to correctly compute that if the statement in Cell J10 reads - "Radio - KLBJ" it will recognize that that rate is .05 and multiple corretly. My trouble I am having now, is I need to add :"RADIO - KVET - (LM) 302" & "[FONT=arial, sans, sans-serif]LISTING INQUIRY - CALL/INTERNET/ETC - (BM) 203" to be multiplied at .05 as well. Anything else *.1[/FONT]

[FONT=arial, sans, sans-serif]Am I making any better sense here? I appreciate your insight into my issue.


[/FONT]
 
Upvote 0
:"RADIO - KVET - (LM) 302" & "LISTING INQUIRY - CALL/INTERNET/ETC - (BM) 203

=IF(J10="RADIO - KLBJ - (LM) 301",R10*0.05,R10*0.1)

Change to
=IF(OR(J10="RADIO - KLBJ - (LM) 301", J10="LISTING INQUIRY - CALL/INTERNET/ETC - (BM) 203"), R10*0.05,R10*0.1)

 
Upvote 0
just seen you want to add another 2 names

=IF(OR(J10="RADIO - KLBJ - (LM) 301", J10="RADIO - KVET - (LM) 302" , J10="LISTING INQUIRY - CALL/INTERNET/ETC - (BM) 203"), R10*0.05,R10*0.1)
 
Upvote 0
You must log in or register to reply here.

Similar threads

O
  • Question Question
Approaching deadline!!!
Replies
2
Views
686
SpillerBD
S

Forum statistics

Threads
1,222,900
Messages
6,168,926
Members
452,227
Latest member
sam1121

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top