|
|
|
|
"VC" ha scritto nel messaggio
I understand that up to seven IF functions can be nested as
value_if_true and value_if_false arguments to construct more
elaborate tests.
Not seven nested IF, but seven *level* of nested IF... ;-)
For example you can use this function I found somwhere on the net with up to
26 nested IF:
=IF(OR(B2="a",B2="b",B2="c",B2="d",B2="e",B2="f"), IF(B2="a",1,IF(B2="b",2,IF(B2="c",3,IF(B2="d",4,IF (B2="e",5,6))))),IF(OR(B2="g",B2="h",B2="i",B2="j" ,B2="k",B2="l"),IF(B2="g",7,IF(B2="h",8,IF(B2="i", 9,IF(B2="j",10,IF(B2="k",11,12))))),IF(OR(B2="m",B 2="n",B2="o",B2="p",B2="q",B2="r"),IF(B2="m",13,IF (B2="n",14,IF(B2="o",15,IF(B2="p",16,IF(B2="q",17, 18))))),IF(OR(B2="s",B2="t",B2="u",B2="v",B2="w"), IF(B2="s",19,IF(B2="t",20,IF(B2="u",21,IF(B2="v",2 2,23)))),IF(B2="x",24,IF(B2="y",25,IF(B2="z",26,"e rror
- type a letter")))))))
If you copy this function in a cell, say C2, and you type a letter from A to
Z in B2, in C2 you'll have the position of the typed letter in the alphabet.
I think you can adapt this function to your needs.
--
Hoping to be helpful...
Regards
Franz
----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------
|