Assuming you mean in a spreadsheet using worksheet formulas
Generally you can satisfy the requirement with a lookup table or using
Choose or some other combination of formulas - it depends on what you are
trying to do.
A workaround is to split your conditions between two top level conditions
then you can work down each side.
Chip Pearson has an example:
http://www.cpearson.com/excel/nested.htm
--
Regards,
Tom Ogilvy
"Kreller " wrote in message
...
Apparently it is not possible to embed more than 7 formulas in one, e.g
(if...then(if...then)), etc. Do you have a suggestion to how I can
"hotwire" that and make a e.g. a macro to embed more formulas or solve
the same task in a different way?
---
Message posted from http://www.ExcelForum.com/