ExcelBanter - Formula if a number is between 2 amount than answer will be x

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula if a number is between 2 amount than answer will be x (https://www.excelbanter.com/excel-worksheet-functions/70498-formula-if-number-between-2-amount-than-answer-will-x.html)

Princess

Formula if a number is between 2 amount than answer will be x

I need help please!!! For example if I am in cell C3. I want to put a formula
in that if in B3 the number I have entered is between 4 and 6 for example
than i want the answer in C3 to be 2.

[email protected]

Formula if a number is between 2 amount than answer will be x

"Princess" wrote:
I want to put a formula in that if in B3 the number I
have entered is between 4 and 6 for example
than i want the answer in C3 to be 2.

You also need to specify what value you want if B3 is not
between those limits. I will use 1 ....

=IF(AND(4<=B3,B3<=6), 2, 1)

All times are GMT +1. The time now is 05:49 AM.