2017-12-18 11:05:20 +0200 marked best answer Need formula using ifs Have a range of numbers 1 - 60. I want to make a choice depending on a range of numbers i.e. If the number is between 1 and 10 then do THIS if the number is between 11and 20 do THAT if the number is between 21 and 40 do SOMETHING ELSE if the number is between 41 and 50 do XYZ if the number is between 51 and 60 do ABC The THIS/THATetc names relate to formula. 2017-12-18 11:03:29 +0200 received badge ● Famous Question (source) 2017-12-18 10:45:43 +0200 received badge ● Notable Question (source) 2017-09-10 00:42:19 +0200 commented answer Hide range in certain conditions I either misread or mistyped the instructions. I also found another way to accomplish the hiding - just format the type 2017-09-09 06:45:01 +0200 received badge ● Popular Question (source) 2017-09-08 23:41:49 +0200 edited answer Hide range in certain conditions Partially working.......Input cell is C16 Range to hide is J3:Q14 Formula is $C$16>125.7 When cell C16 is less than 2017-09-08 22:44:41 +0200 answered a question Hide range in certain conditions Partially working.......Input cell is C16 Range to hide is J3:Q14 Formula is $C$16>125.7 When cell C16 is less than 2017-09-08 16:24:05 +0200 asked a question Hide range in certain conditions Hide range in certain conditions Is it possible to hide a named range under certain conditions. If cell A1 >5 and c 2017-09-08 13:51:55 +0200 received badge ● Notable Question (source) 2017-09-08 13:50:05 +0200 answered a question Need formula using ifs Thx - I had an ah-hah moment in the middle of the night and came up with the vlookup solution. 2017-09-08 08:28:39 +0200 received badge ● Popular Question (source) 2017-09-07 22:52:57 +0200 asked a question Need formula using ifs Need formula using ifs Have a range of numbers 1 - 60. I want to make a choice depending on a range of numbers i.e. If t