if condition in multi case.....

**amarjeet.it** · 04-15-2013, 06:17 AM

hi i want to use if formula shows here in attached file.....

IF "F10" is less than "B1" and greater then "B2" then output should be "F10", otherwise "B1" should be displayed.

Please help

thanx in advance

**sbkeenan** · 04-15-2013, 06:27 AM

Hi

I've had a brief look at your sample spreadsheet and think that your logic is flawed. You have the values 4 and 8 in cells B1 and B2, respectively. Therefore, it is not possible for a value in cell F10 to be less than B1 AND greater than B2, i.e a value cannot be less than 4 AND greater than 8, it's either one or the other!! Please can you clarify.

Regards
Stephen.

**amarjeet.it** · 04-15-2013, 06:37 AM

sorry for not to convey the core problem idea. moreover i have this is like in new sheet......

case-I: if value is more than 8 or equal to 9 then it would show 8...............

otherwise if value is less than 8 or more than 9 then it would show the same value what it is.

**amarjeet.it** · 07-07-2017, 03:05 AM

finally i have got this solution,
if(and(F10>=8,F10<=9),"8",F10)

Thannx for ur kind concern...

**JohnTopley** · 07-07-2017, 03:12 AM

Your solution should be

=if(and(F10>8,F10<=9),8,F10)

the 8 should NOT be in quotes as it will be treated as text rather than a number (which can cause problems later).

and your post says more than 8 NOT greater or equal: which is it?