Conditions between two values

Hi,

you just need to place the condition in the formula like the others while respecting the ascending or descending order

=IF(AND(B3>=14,B3<=16.75),"long",IF(AND(B3>=8,B3<=13.75),"Flat",IF(AND(B3>0,B3<=4),4,"total of the cell")))

--
Best,
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.

Wonderful, it works !!!!! Thank you so much !!

Hello

=IF(AND(A1>=8,A1<=13.75),"Flat Rate",IF(A1>=14,A1<=16.75,"long",""))

regards

--
To err is human, to persist is diabolical

It doesn't work...

Actually, I have 3 conditions
less than 4 = 4
between 8 and 13.75 = flat rate; otherwise the cell total
between 14 and 16.75 = long; otherwise the cell total

Hello,

try it like this

=IF(AND(B3>=8;B3<=13.75);"Flat rate";IF(AND(B3>=14;B3<=16.75);"long";"total of the cell"))

but there is a gap what to do between 13.75 and 14 and according to your last post between 4 and 8 what to do, it's not very clear

would it not be a question of >=14 long and >= 8 flat rate and less than 8 nothing in this case

=IF(B3>13.75;"long";IF(B3>=8;"flat rate";"total of the cell"))

See you +
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.

... and you promise us that a fourth condition won't be added?

--
Retirement is great! Especially in the Caribbean ... :-)
Raymond (INSA, AFPA, CF/R)