Sliding Scale Formula in Excel

Hi,

For starters you might like to try this in C1:

=IF(B1<3,A1*.7,IF(B1<4,A1*.8,If(B1<5,A1*.9,A1)))

It seems to work for me, also providing 100% of A1 where B1 is not less that 5. You might also note that it is the reverse order you specified it, as you need to catch the lowest values first. I am presuming you mean &quot;less than 5 and not less than 4&quot;, &quot;less than 4 and not less than 3&quot;, &quot;less than 3&quot;.

You might need to look for a more sophisticated solution if you have many more levels to check for.

HTH

Good Luck!

Peter Moran

Thanks very much for the formula, Peter. I was having a bit of a &quot;gray-out&quot; with my problem-solving last night.

I appreciate your time and support of Tek Tips!

-Bob in California

(Surf's Up!)

Hi Bob,

Pssssssssssssssst. (I hope you can hear me over that wonderful sound of the surf !)

I know you've been VERY responsive with your awarding STARS in the past, so I know this was an &quot;oversight&quot;. Your sight was probably obscured by having one eye on that surf ! ;-)

Best Regards, ...Dale

Greetings, Dale,

No oversight on my part; my problem is that I cannot award stars from home off of this computer. Perhaps I should address this to the forum: Do you think it is because of the new software I have put on this computer? It is called, &quot;AdSubtract&quot; and it blocks ads, banners, popups.

What do you think, Dale?

Very Best Regards,

Bob

Hi Bob,

My apologies... I really should have known, because you had mentioned a problem before, just not the specifics.

It IS an interesting problem, and YES, I agree that you should try a separate posting on Tek-Tips. The only question is &quot;which&quot; forum would be the best.

It might have been a while since you last picked your forums, so in case this will help...

1) On the top-left-corner of the Tek-Tips screen, click “Subscribe to Forums”.

2) The next screen will have: Areas, with Categories for each Area.

Under Areas ...DeskTop Systems, there’s “Desktop Software”. After selecting this, on the right side under Categories you’ll see “Personal Information Managers”.

Another possibility... Areas: MIS/IT - Category: Security Solutions.

I hope this helps. “Good Hunting”

Best Regards, ...Dale

Thanks, Dale. I will give this a try when a have a few spare moments.

Your advice is always appreciated, and it is always good to hear from you.

I hope your week is pleasant.

-Bob in California