Nesting If Statements-----ARRRGGGH!!

[Dargie]

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,"Adult","")
=IF(B3<18, "Child","")

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

Cheers Steve

 

[GorD]

=IF(B3>=18,"Adult",if(B3<18,"child",""))

 

[ken2step]

=IF(B3="","",IF(B3>=18,"Adult","Child"))

 

[ken2step]

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

 

[Dargie]

Cheers Folks

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

Many Thanks


Steve

 

[Dargie]

=IF(B3>=18,"Adult","")
=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

 

[ken2step]

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.

 

[Dargie]

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


=IF(B3="","",IF(B3>=18,"adult","child"))

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

 

[ken2step]

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

 

[Dargie]

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

Cheers Steve