Hello, I'm new to if, and formulas with this one returning a fault which I've tried numerous ways but obviously not the right way..
What I want is cell B24 will have 1 of 5 numbers,
Cell C24 a number between a range,
Another cell will return a given number,
IF((B24=25)(C24>3.4,C24<4.5),7)IF((B24=25)(C24=4.5,C24<5.5),8)
Hope this is clear enough for what I'm chasing? Appreciate some help please.
What I want is cell B24 will have 1 of 5 numbers,
Cell C24 a number between a range,
Another cell will return a given number,
IF((B24=25)(C24>3.4,C24<4.5),7)IF((B24=25)(C24=4.5,C24<5.5),8)
Hope this is clear enough for what I'm chasing? Appreciate some help please.