• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to build a nested IF statement to determine if # is between values

DenKon

New Member
Looking to build a nested IF statement to help determine the below.

If A1 =>50 return a 40
If A1 is between 49.99 and 46.00 return a 30
If A1 is between 45.99 and 42.00 return a 5
If A1 is =<41.99 return a 0

A1 will contain a number anywhere between 0 - 100 (ex. 45.8674635 or 42.6984635).

I've been unsuccessful thus far so any help is appreciated. Thank you!
 
Different possibility's but I would go for @John Jairo V =LOOKUP(A1,{0,42,46,50},{0,5,30,40}) easier cleaner and easy to expand
Thank you. I initially utilized John Jairo V's IF function solution which worked just fine but I decided to try your LOOKUP solution . . . . fantastic and yes, I agree so easy to expand!!! Awesome, really appreciate the assistance!!!
 
Back
Top