Anyone good with nested formulas?

Lil306

Muchos gracias, I love all the replies. Helping me understand the nested and validation a lot better. Think I'm going to have to buy one of those geek books

EDIT - Didn't realise I had to share it

This link should work
Link Me

Lokolo

Don't use B2=0 to mean B2 is blank. You should use B2="".

So if you have this:

If the value entered in Column D, was <2 - it would produce "Day-Tripper" in E
If the value entered in Column D, was >30 - it would produce "Too Long" in E
Otherwise, leave the column E blank

Then you would have an if statement look like this:

If D < 2
->PRINT "Day Tripper"
Else
->If D > 30
->->PRINT "Too Long"
->Else
->->LEAVE BLANK
->End if
End if

which would equate to:

=IF(D<2,"Day Tripper",(IF(D>30,"Too Long","")))

Lil306

Lokolo wrote: »

Don't use B2=0 to mean B2 is blank. You should use B2="".

So if you have this:

If the value entered in Column D, was <2 - it would produce "Day-Tripper" in E
If the value entered in Column D, was >30 - it would produce "Too Long" in E
Otherwise, leave the column E blank

Then you would have an if statement look like this:

If D < 2
->PRINT "Day Tripper"
Else
->If D > 30
->->PRINT "Too Long"
->Else
->->LEAVE BLANK
->End if
End if

which would equate to:

=IF(D<2,"Day Tripper",(IF(D>30,"Too Long","")))

Ty, always good to learn