by Bob Philli » Thu, 02 Feb 2006 02:09:04
Then add this to E13
=IF(C13="Spruce Creek",34,IF(C13="Stone Creek",10,IF(C1="Fore Ranch",6,"")))
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
=IF(AND(OR(cell1="text1",cell1="text2",cell1="text3"),cell2=integer1),action
the