Formula for lookup or what if

**chickieram63** · 04-04-2011, 05:52 PM

I need a formula stating:
If a number is 25% or higher then no credit
if a number is 24.9 to 15% then $1500
if a number is 14.9 to 0% then $2000 credit

I've tried looking online, and haven't been able to come up with one as I am not a beginner, but definitely not advanced!

**Roger Govier** · 04-04-2011, 06:04 PM

Hi

Try

Please Login or Register  to view this content.

Format the cell with result as Currency.

**chickieram63** · 04-04-2011, 11:24 PM

Originally Posted by chickieram63

I need a formula stating:
If a number is 25% or higher then no credit
if a number is 24.9 to 15% then $1500
if a number is 14.9 to 0% then $2000 credit

I've tried looking online, and haven't been able to come up with one as I am not a beginner, but definitely not advanced!

It worked like a charm! Thank you so much.