nested functions using insert function

[Annie]

I'm using excel 2003 and am trying to create ifand functions using the insert
function button. It will only allow me to do one or the other, not both. Is
it possible to nest functions using insert function or do I have to put them
in the long way round?

 

[Bob Phillips]

You can to an extent by embedding another function or functions in say the
logical_test part of an IF test, but you only get to use the wizard for the
outermost function. Easier to hand-cut IMO, I never use the wizard.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)