Forum Discussion
Real Estate Commission formula help
I’m trying to build a worksheet to help me track my real estate business. I’ve gotten the worksheet to calculate most of my data but I’m having on issue. When I complete a sale I get a commission whi...
Hi Tim,
Perhaps
=IF(SUM(E$1:E2)+D3*$K$5<=$J$2,D3*$K$5,IF((SUM(E$1:E2)+D3*$K$5>=$J$2)*(SUM(E$1:E1)+D2*$K$5>=$J$2),100,$J$2-SUM(E$1:E2)))
and attached if I understood your logic correctly
That did the trick. Now I'll see if I can make the adjustment for the change in calendar year.
Thanks!!!!
Tim
