# Nesting If Statements-----ARRRGGGH!!

#### Dargie

##### New Member
Nesting IF Statements

hello Folks

Can anyone help me out with this one

Heres a wee example of the kind of thing i need to do
Age is in column B3 Formula is in column B4

=IF(B3<18, "Child","")

How can these be nested together into one statement.
All help appreciated

Cheers Steve

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Better check that one GorD.....I don't think that one works. I know because I tried it......lol.

Cheers Folks

I'll try those out and see how i get on with them

Many Thanks

Steve

=IF(B3<18, "Child","")
hi again

is there any way that the second argument could contain an Or statement

im not relly too sure about these ones at all

=IF(B3<18 or >0,"child","")

Thanks

No need for an OR for waht you asked for....the one I give you does just that.
If your worried about others entering a number less than or equal to 0, then Validate B3 as Whole Number greater then Zero.

If B3 is left blank, then the text does not show, i can see this in the formula, so thats working fine.
=If(B3="","",

But if i enter any number in b3 from 1 upwards it comes back adult for all values

I have pasted in the formula from the formula bar

Dont understand, as the way im reading your formula, it should work fine.
I can understand the basic If statements, it's joining them thats got me lost

It works just fine for me.......

i'll try a fresh one and start again
maybe i mucked something up

Cheers Steve

Replies
4
Views
265
Replies
17
Views
342
Replies
0
Views
245
Replies
1
Views
287
Replies
5
Views
684

1,203,488
Messages
6,055,716
Members
444,811
Latest member
NotJack

### 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