Formula Query - TRUE WHEN NUMBER LIES BETWEEN TWO PARAMETRES

I'm trying to create an "IF" formula that will trigger if a number lies between two parametres. Eg. TRUE if 25 lies between 20 & 30. Any idea?

Welcome to the forum, Danto.

In order to avoid having to answer the same questions every day, we require that posters compose thread titles that make the forum usefully searchable. Your title doesn't advance that goal.

Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.

Much better, thanks.

=if(and(a1>=25, a1<=30), trueResult, falseResult)

trueResult and falseResult can be any valid expression.

If you only want a true/false result,

=and(a1>=25, a1<=30)

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes