Nesting IF statements with {..}

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Found a formula with IF statements nested with {..} at its begining and end. Can not edit the statement. When I do, even if I make no changes, the brackets remove thenselves and the formula no longer works. What gives.

Thanks for the help.
 
Mico,

It sounds like you have an array formula. With these, you don't type the
{ }, Excel adds them when you enter with Ctrl-Shift-Enter, rather than just
Enter.So edit the formula, and then Ctrl-Shift-Enter, and you should be
there.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Mico said:
Found a formula with IF statements nested with {..} at its begining and
Click to expand...
end. Can not edit the statement. When I do, even if I make no changes, the
brackets remove thenselves and the formula no longer works. What gives.
 

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

Simple nested if and statement 2
Help with Nested IF Statements 4
Nesting a nested function with {..} 1
Formula nesting with IF statements 2
Nested IF(OR(AND) Statement with Two AND Conditions 6
Nested IF statement 4
Nested If/And/Or statements 4
Exceeding Limit on Nested IF Statements 4

Back
Top