| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparison Formula
Hi there!
Need help with a formula that will solve the problem below: if b17 is LESS than 30 and c17 is GREATER than 84 or b17 is LESS than 30 and c17 is greater than 85 but less than 108, "true", "false" Please help! I just about pulled out my last hair! Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparison Formula
Hi!
I just about pulled out my last hair! Well, at least you have some left! =IF(AND(B17<30,C1785,C17<108),"True",IF(AND(B17<3 0,C1784),"True","False")) Biff wrote in message oups.com... Hi there! Need help with a formula that will solve the problem below: if b17 is LESS than 30 and c17 is GREATER than 84 or b17 is LESS than 30 and c17 is greater than 85 but less than 108, "true", "false" Please help! I just about pulled out my last hair! Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparison Formula
Thank you! You've saved my last hair!
|
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparison Formula
You're welcome!
Biff wrote in message oups.com... Thank you! You've saved my last hair! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| formula for comparison | Excel Discussion (Misc queries) | |||
| Time comparison formula | Excel Discussion (Misc queries) | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
