In such cases it's usually best to create a datalist and incorporate one of
the lookup functions into your formula.

Post back with the details and I'm sure you'll receive suggestions.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"HARSH BAHAL" <HARSH wrote in message
...
The formula I want to set requires 15 " IF " qualifiers. How to set set
such
a formula ?