Braswell, Brian <Brian.Braswell <at> Zurn.com> writes: ... > I opened up a spreadsheet ... and the multiple If/Then statements were apparently not valid in your program. .... Does your program even support multiple if/then statements, random 1 through 10, random 1-100 statements? ... I had to adjust to different methods for handling this as well. You may get some help, as I eventually did, from the functions AND and OR (in Help under AND function and OR function). Hereunder a sample from one of my files: =(IF(I7<=1;1;IF(AND(I7>1;I7<=15);I7;IF(AND(I7>15;I7<=25);15+((I7-15)*0.3);IF (AND(I7>25;I7<=50);18+((I7-25)*0.2);IF(I7>50;23+((I7-50)*0.1)))))))
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
