First time here? Check out the FAQ!

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 |

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.