Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nested functions using insert function
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nested functions using insert function
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) "Annie" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested IF functions | Excel Discussion (Misc queries) | |||
too many nested IF functions | Excel Worksheet Functions | |||
How do I enter a function that has more than 7 nested functions | Excel Worksheet Functions | |||
NESTED IF FUNCTIONS | Excel Worksheet Functions | |||
Several function questions (nested functions) | Excel Worksheet Functions |