Hey Everyone, i'm a bit rusty at this. Trying to get a formula to work where if C70 is less than 100, *.20, if its between 101-250, *.15, if between 251-2500, *.10, and anything above 2500, *.05. Hope this all make sense.
Hey Everyone, i'm a bit rusty at this. Trying to get a formula to work where if C70 is less than 100, *.20, if its between 101-250, *.15, if between 251-2500, *.10, and anything above 2500, *.05. Hope this all make sense.
This will do it:
Formula:Please Login or Register to view this content.
(You didn't say what you wanted if equal to 100, so I assumed 'less than or equal to'.)
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Another way:
=C70 * LOOKUP(C70, {0,101,251,2501}, {20,15,10,5}%)
Entia non sunt multiplicanda sine necessitate
or a slightly different way from shg's... =C70*LOOKUP(C70,{0,100,250,2500},{0.2,0.15,0.1,0.05})
but since I worked on it for a while I thought I'd post it anyway.
Last edited by Sam Capricci; 11-29-2016 at 02:56 PM.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thanks Everyone. Both Ways work great!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks