Hi
you could always used nested IF conditions. To give you an example
=IF(AND(A10,B10),"A1+B1 0",IF(OR(A10,B10),"A1 or B1 are 0","None
is greater than zero"))
Note: The maximum are 7 nested function calls
--
Regards
Frank Kabel
Frankfurt, Germany
Peter L wrote:
Oki, I see how you mean. But I´m looking for the principle to write
multiple conditions
/Peter
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!