Here are the formulas:
1. If A1 <= n and B1 <= n than C1 = (A1 * B1 * K)
2. If A1 >= n and B1 <= n than C1 = (A1 * B1 * K)
3. If A1 <= n and B1 >= n than C1 = (A1 * B1 * K)
4. If A1 >= n and B1 >= n than C1 = (A1 * B1 * K)
• A1, B1, C1 ==> Cells
• N ==> Numer
• K ==> Coefficient
Bookmarks