Hi
=IF(condition1,NumValue1,0)+IF(condition2,NumValue2,0)+...+IF(condition30,NumValue30,0)
=IF(condition1,TextValue1,"")&IF(condition2,TextValue2,"")&...&IF(condition30,NumValue30,0)
,or the same in shorter way (vor numeric responses only)
=(LogicalCondition1)*NumValue1+(LogicalCondition2)*NumValue2+...+(LogicalCondition30)*NumValue30
Or enter lookup table onto some sheet, and use VLOOKUP to get right value
(text or number) from there.
--
Arvi Laanemets
( My real mail address: arvil<at>tarkon.ee )
"How do I put in more than 7 validations" <How do I put in more than 7
validations @discussions.microsoft.com> wrote in message
news:
[email protected]...