rudebwoyrohan
New Member
- Joined
- Jul 4, 2015
- Messages
- 2
I need a formula in B7 to pick the lesser of B5 and B6. I keep getting a circular reference. Please assist if you can. Thank you.
<tbody>
</tbody>
A | B | C | ||
1 | Rate 1 | 0.57 | ||
2 | Rate 2 | 0.75 | ||
3 | Rate 3 | 200 | ||
4 | Rate 4 | 0.001 | ||
5 | Cap | =ROUND(IF(ROUND(B3*B4,6)>B8*30%,B8*30%,ROUND(B3*B4,6)),6) |
<tbody> </tbody><colgroup><col></colgroup> | |
6 | Calculated Fee | =B3*B4 | ||
7 | Admin Fee |
<tbody> </tbody><colgroup><col></colgroup> | ||
8 | Rate A | =B1-B7 | ||
9 | Rate B |
<tbody> </tbody><colgroup><col></colgroup> |
<tbody>
</tbody>