# Can someone halp me to colligate these 4 diferent formulas in one?

1. ## Can someone halp me to colligate these 4 diferent formulas in one?

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  Register To Reply

2. ## Re: Can someone halp me to colligate these 4 diferent formulas in one?

There has to be something wrong with what you have presented. All the combination of conditions result in the same result.  Register To Reply

3. ## Re: Can someone halp me to colligate these 4 diferent formulas in one?

no, its not the same. let me explain more specifically.

1. If A1 <= 1.6 and B1 <= 1.6 than C1 = (A1 * B1 * 0.92)
2. If A1 >= 1.6 and B1 <= 1.6 than C1 = (A1 * B1 * 0.94)
3. If A1 <= 1.6 and B1 >= 1.6 than C1 = (A1 * B1 * 0.96)
4. If A1 >= 1.6 and B1 >= 1.6 than C1 = (A1 * B1 * 0.98)

"n" its u number. in these case is 1.6 but it may be 1.55 so it's not the same. Also K is a coefficient that may change. It depends from the terms of cell a1 and cell b1.  Register To Reply

4. ## Re: Can someone halp me to colligate these 4 diferent formulas in one?

no, its not the same. let me explain more specifically.

1. If A1 <= 1.6 and B1 <= 1.6 than C1 = (A1 * B1 * 0.92)
2. If A1 >= 1.6 and B1 <= 1.6 than C1 = (A1 * B1 * 0.94)
3. If A1 <= 1.6 and B1 >= 1.6 than C1 = (A1 * B1 * 0.96)
4. If A1 >= 1.6 and B1 >= 1.6 than C1 = (A1 * B1 * 0.98)

"n" its u number. in these case is 1.6 but it may be 1.55 so it's not the same. Also K is a coefficient that may change. It depends from the terms of cell a1 and cell b1.  Register To Reply

5. ## Re: Can someone halp me to colligate these 4 diferent formulas in one?

This is what your 4 formulae come down to in 1 formula:

Formula:  `Please Login or Register  to view this content.`

The values 1.6, .92, .94, .96, .98 can be replaced by cell references. For example, the "K" values could be in cells K2:K5 and the "N" value could be in another cell.

I don't know how you arrive at the "N" and "K" values so cannot help you further at this time.  Register To Reply

6. ## Re: Can someone halp me to colligate these 4 diferent formulas in one?

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.  Register To Reply

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1