Excel 2007 problem nesting IF & AND

S

Steve

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?

Not sure if this is relevant, but when I am in the function Wizard for
the nested and, if I pressed tab after the second argument, the
dialogue box corrupts - showing the third argument box covering the
dialogue box text below.

TIA

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 problem nesting If & And 3
Page numbering with Merged Document and IF statements 1
VBA concatenate ranges into a new document 0
IF function says too many nested 1
Template with fields and premade texts.. 0
Problem with SET & REF function 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Simple nested if and statement 2

Top