Formula string for multiple conditions not working.

**tkc** · 08-16-2012, 12:03 PM

Hello,

First post...brand new Excel user and less than savvy computer user...

Trying to accomplish:

If cell B6 is greater than 0, but less than or equal to 100, then multiply B6 by 2.2 and display answer in C6
If cell B6 is greater than 100, but less than or equal to 200, then multiply B6 by 2 and display answer in C6
If cell B6 is greater than 200, but less than or equal to 500, then multiply B6 by 1.7 and display in C6
If cell B6 is greater than 500, then multiply B6 by 1.4 and display answer in C6

I can get the formula for the first condition to work, but don't know how to string together the next 3 conditions...

Thanks!!
TKC

**CheshireCat** · 08-16-2012, 12:17 PM

How about:

Please Login or Register  to view this content.

**tkc** · 08-16-2012, 12:21 PM

That works perfect! I NEVER would have come up with that...

Thanks CheshireCat!!

TKC

**tkc** · 08-16-2012, 02:42 PM

Uh oh...

One problem, when there is no value in the B6 cell, C6 shows "#N/A". Is there a way to either zero out that cell, or have it be blank when there is no value in B6? (In my original question, I mistakenly put B7...should have been C6)

Thanks again!
TKC