Ask Your Question

dogluvver's profile - activity

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