How to return a number between to numbers
Eg: if the value is 75, and I have set of prefixed ranges such as 110, 1150, 51100, 101200 etc.
Since this value lies between the range 51100, i want the value to be returned as 51100.
Answers

You'll need to create nested IF formulas with AND logic expression. such as:
=IF(AND(Number@row>50, Number@row<101), "51100", IF(...

One approach is to use the IF() function. It works like this:
IF( logical_expression , value_if_true , value_if_false )
...another way to write it so that it's easier to follow:
IF( logical_expression , value_if_true , value_if_false )
You'll need to use nested IF() expressions since you're evaluating for 4 conditions: "110", "1150", "51100", "101200".
Assuming that the number you're evaluating is in a column named, "thisNumber", your process in nearplain English might be:
...IF thisNumber is greater than 100 , True! it must be "101200" , False! now let's check IF thisNumber is greater than 50 , True! it must be "51100" , False! now let's check IF thisNumber is greater than 10 , True! it must be "1150" , False! it is "110"
Written in syntax that Smartsheet will understand:
IF( thisNumber@row > 100 , "101200" , IF( thisNumber@row > 50 , "51100" , IF( thisNumber@row > 10 , "1150" , "110" ) ) )
Flattened for cutpaste into Smartsheet:
= IF(thisNumber@row > 100, "101200", IF(thisNumber@row > 50, "51100", IF(thisNumber@row > 10, "1150", "110")))
You can find a list of all Smartsheet functions and related documentation here:
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives