Alright, I know this is Google Sheets and not excel, but I've been trying to build a tracker for my real estate team for a while. No matter what I find on here or Google, I can't seem to solve the problem.
Our brokerage charges a 15% fee to a maximum of $6,000. I'm trying to get the N column to continue to take 15% up to the $6,000 maximum and to return $0 as the value after that. The issue I'm having is that I create a loop with any IF statements I try and I'm not sure what else I can use.
I saw a post with someone doing something similar and tried a formula with a LOOKUP, SUBTOTAL, and OFFSET functions. Maybe it's just that I don't have a full enough understanding of those functions to modify them for my situation. Please help. I've just been manually inputting for the last year because I hate bothering people with questions that I can figure out myself, but I think this one is beyond my googling abilities haha.
docs.google.com
Our brokerage charges a 15% fee to a maximum of $6,000. I'm trying to get the N column to continue to take 15% up to the $6,000 maximum and to return $0 as the value after that. The issue I'm having is that I create a loop with any IF statements I try and I'm not sure what else I can use.
I saw a post with someone doing something similar and tried a formula with a LOOKUP, SUBTOTAL, and OFFSET functions. Maybe it's just that I don't have a full enough understanding of those functions to modify them for my situation. Please help. I've just been manually inputting for the last year because I hate bothering people with questions that I can figure out myself, but I think this one is beyond my googling abilities haha.
Copy of REAL Agent Volume Tracker
Sheet1 Closed?,Closing Date,Address,Price,Commission %,Adjusted Volume,Transaction Fee,Referral Fee,Paid to Agent,Paid towards Team,TL Cap,G or D,Paid towards REAL,REAL Cap:,$6,000.00 Y,122 Example Ln,$250,000.00,3.00%,$250,000.00,$0.00,$0.00,$3,825.00,$3,000.00,$450.00,Gloria,$675.00 Y,123 Exa...
