M moknows Joined Aug 20, 2014 Messages 1 Reaction score 0 Aug 20, 2014 #1 I need help with this formula. I am trying to get a value based on a range of numbers =IF(B17>1,"75",IF(B17>11,"100",IF(B17>22,"150",IF(B17>27,"200"))))
I need help with this formula. I am trying to get a value based on a range of numbers =IF(B17>1,"75",IF(B17>11,"100",IF(B17>22,"150",IF(B17>27,"200"))))
