you're right..

i just want to know here, (other than lookup results) if the number of
different value-if-true results...requires more than 7 and are structured
independently..... then nesting Maybe is a must...
let's wait for AcademyAce to post his formula n Results needed... he sounds
like an experienced excel user.

"daddylonglegs" wrote:

With 10 options it's usually better to use some sort of LOOKUP formula. If
you have the most simple structure like

IF(A1="a",2,IF(A1="b",3 ......etc then this can usually be simplified by
constructing a 2 column table and using a VLOOKUP formula

"AcademyAce" wrote:

I have used up all seven nested functions in my formula but still have three
arguments left. I want to include them in the same cell.