Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 problem nesting If & And
Help Please!
I need to teach people how to use nested if & And functions. I have no problem with doing this by simply typing in the functions, however I have to show them Excel 2007s function Wizard. I am finding whenever I try to nest the AND inside the IF as soon as I click the okay button on the AND function dialogue box I am being given an error message,saying that the formula I typed contains an error. It certainly isn't an error in the function, because Excel leaves the IF with the nested and in the formula bar, and I can fifnish the function from there. however, I would like to complete the nested functions using the function Wizard. Any ideas if I'm doing something wrong, or if this is a bug? TIA Steve |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Apologies for double-post!
On Tue, 03 Feb 2009 11:26:53 +0000, Steve < wrote:
Help Please! I need to teach people how to use nested if & And functions. I have no problem with doing this by simply typing in the functions, however I have to show them Excel 2007s function Wizard. I am finding whenever I try to nest the AND inside the IF as soon as I click the okay button on the AND function dialogue box I am being given an error message,saying that the formula I typed contains an error. It certainly isn't an error in the function, because Excel leaves the IF with the nested and in the formula bar, and I can fifnish the function from there. however, I would like to complete the nested functions using the function Wizard. Any ideas if I'm doing something wrong, or if this is a bug? TIA Steve |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 problem nesting If & And
I can replicate the problem you are having (using XL2007). Whether it's a
bug or a "feature" would be in the eyes of the beholder. I've tried nesting other functions with the same result. It looks to me like the function wizard does not handle nested functions. Regards, Fred. "Steve" wrote in message ... Help Please! I need to teach people how to use nested if & And functions. I have no problem with doing this by simply typing in the functions, however I have to show them Excel 2007s function Wizard. I am finding whenever I try to nest the AND inside the IF as soon as I click the okay button on the AND function dialogue box I am being given an error message,saying that the formula I typed contains an error. It certainly isn't an error in the function, because Excel leaves the IF with the nested and in the formula bar, and I can fifnish the function from there. however, I would like to complete the nested functions using the function Wizard. Any ideas if I'm doing something wrong, or if this is a bug? TIA Steve |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 problem nesting If & And
Thanks for that Fred. at least I know it's not me!
On Tue, 3 Feb 2009 09:20:31 -0600, "Fred Smith" wrote: I can replicate the problem you are having (using XL2007). Whether it's a bug or a "feature" would be in the eyes of the beholder. I've tried nesting other functions with the same result. It looks to me like the function wizard does not handle nested functions. Regards, Fred. "Steve" wrote in message ... Help Please! I need to teach people how to use nested if & And functions. I have no problem with doing this by simply typing in the functions, however I have to show them Excel 2007s function Wizard. I am finding whenever I try to nest the AND inside the IF as soon as I click the okay button on the AND function dialogue box I am being given an error message,saying that the formula I typed contains an error. It certainly isn't an error in the function, because Excel leaves the IF with the nested and in the formula bar, and I can fifnish the function from there. however, I would like to complete the nested functions using the function Wizard. Any ideas if I'm doing something wrong, or if this is a bug? TIA Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 problem nesting IF & AND | Excel Worksheet Functions | |||
Nesting Problem | Excel Discussion (Misc queries) | |||
Excel 2007 backwards compatibility - nesting functions | Excel Worksheet Functions | |||
HLP! Nesting Problem?? | Excel Worksheet Functions | |||
Nesting Problem | Excel Worksheet Functions |