# dumbass nested if question

#### rodney_malodney

##### Board Regular
ok forgive my stupidity here

i wish to get a result of "true" to show if sometihng is between two limits 151 and 300, i believe i need a nested if but can get it to work.

### Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

#### ChrisM

##### Well-known Member
=IF(AND(A1 >= 151, A1 <= 300), "TRUE", "FALSE")

#### nbrcrunch

##### Well-known Member

I've had days like that where my brain can't even do simple stuff and I'm knocking my head against a wall. It is so embarrassing.

Scenario:
A1 has value of 10 and you want, in cell B1 to find if the value is between 5 and 15:

In B1:
=and(A1>4,A1<16)

-----
Just noticed Chris got to you before I finished typing. Both of our formulas will work. the "IF" is not really needed for such a simple compare.

#### Andrew Poulsom

##### MrExcel MVP
Example:

Code:
``=AND(A1>151,A1<300)``

#### rodney_malodney

##### Board Regular
only had the and in the wrong place.

god thankgod its nearly home time :D

#### HalfAce

##### MrExcel MVP
If you want, you can do that within the same cell the number is being entered into by using custom formatting instead of using a formula in a different cell.

Format the cell as Custom and use:
Code:
``[<151]General;[>300]General;"True"``
Hope it helps.

Replies
7
Views
325
Replies
5
Views
54
Replies
3
Views
219
Replies
1
Views
92
Replies
0
Views
124

1,195,989
Messages
6,012,718
Members
441,722
Latest member
tpaman1975

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back