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