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

K

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?
 
D

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.
 
K

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
 
A

Andrew

Kreller said:
*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
*
Click to expand...

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

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
[email protected]
Kreller > said:
The formula is basically like this
Click to expand...
=HVIS(Kalender!U7<>"";"x";HVIS(Kalender!V7<>"";"x";HVIS(Kalender!W7<>"";"x";
 
P

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)


Kreller > said:
The formula is basically like this
Click to expand...
=HVIS(Kalender!U7<>"";"x";HVIS(Kalender!V7<>"";"x";HVIS(Kalender!W7<>"";"x";
 
P

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)


Peo Sjoblom said:
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)
Click to expand...
 
A

Andrew

Mr. Sjoblom,

Could you please write that formula in English?
=HVIS(ANTAL.BLANKE(Kalender!U7:AO7)<KOLONNER(Kalender!U7:AO7);"x";"")
Click to expand...

I would appreciate it very much! :
 
Top