Embed more than 7 formulas in one (excel error code: 214124)

[Kreller]

Does anybody know how you can embed more than seven formulas in one
Microsoft's support has given me this highly useful (NOT!!) advice:

"When more than seven levels of embedded IF statements are required
you need to create a function macro, which allows you to break your I
statement over several lines (or formulas)."

However I have no idea how to do that. Do you have a suggestion?

 

[Don Guillett]

It might be best for you to post your formula here for comments.
A LOOKUP formula might be best or a select case macro.

 

[Kreller]

The formula is basically like this

=HVIS(Kalender!U7<>"";"x";HVIS(Kalender!V7<>"";"x";HVIS(Kalender!W7<>"";"x";HVIS(Kalender!X7<>"";"x";HVIS(Kalender!Y7<>"";"x";HVIS(Kalender!Z7<>"";"x";HVIS(Kalender!AA7<>"";"x";"")))))))

(I'm using a Danish version of excel - just replace "HVIS" with "IF

 

[Andrew]

*The formula is basically like this

=HVIS(Kalender!U7<>"";"x";HVIS(Kalender!V7<>"";"x";HVIS(Kalender!W7<>"";"x";HVIS(Kalender!X7<>"";"x";HVIS(Kalender!Y7<>"";"x";HVIS(Kalender!Z7<>"";"x";HVIS(Kalender!AA7<>"";"x";"")))))))

(I'm using a Danish version of excel - just replace "HVIS" with "IF
*

Here is a link that might be useful.
http://j-walk.com/ss/excel/usertips/tip080.ht

 

[Andrew]

Mr. Pearson's advice about using defined names is one way I like.
http://www.cpearson.com/excel/nested.ht

 

[Don Guillett]

look for any number larger than is possible in your data
It sounds like you are trying to find the last value in the row
=MATCH(999999999999,7:7)
will find the last column with a number
=INDEX(7:7,MATCH(999999999999,7:7))
will tell you the number.
--
Don Guillett
SalesAid Software
(e-mail address removed)

The formula is basically like this

=HVIS(Kalender!U7<>"";"x";HVIS(Kalender!V7<>"";"x";HVIS(Kalender!W7<>"";"x";

 

[Peo Sjoblom]

Looks like you want to return "x" if any cell in a contagious range is blank


=HVIS(ANTAL.BLANKE(Kalender!U7:AO7)<KOLONNER(Kalender!U7:AO7);"x";"")

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

The formula is basically like this

=HVIS(Kalender!U7<>"";"x";HVIS(Kalender!V7<>"";"x";HVIS(Kalender!W7<>"";"x";

 

[Peo Sjoblom]

Sorry. meant any cell is not blank

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

Looks like you want to return "x" if any cell in a contagious range is blank


=HVIS(ANTAL.BLANKE(Kalender!U7:AO7)<KOLONNER(Kalender!U7:AO7);"x";"")

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Andrew]

Mr. Sjoblom,

Could you please write that formula in English?

=HVIS(ANTAL.BLANKE(Kalender!U7:AO7)<KOLONNER(Kalender!U7:AO7);"x";"")

I would appreciate it very much! :

 

[Kreller]

Thanks to you, Sjoblom. That was an innovative way of solving th
problem!