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!
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!