Footnote: You can't edit a excel table in mapinfo. (Or, at least, not the version I'm using(6.5)) So, you may have to use excel.
-----Original Message----- From: Sloan Ritchie [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 8:43 AM To: [EMAIL PROTECTED] Subject: RE: MI-L Exchanging Values in MI Easy in Excel: =IF(A1=0,"W",IF(A1<4.5,"G",IF(A1<9.5,"B","R"))) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 8:01 AM To: [EMAIL PROTECTED] Subject: MI-L Exchanging Values in MI Hello I have a spreadsheet with a specific value in each cell. Now I would like to exchange the value with a letter. The following condition should be used for it. * If x is exactly 0 then add a "W" (x=0) * If x is higher than 0, but smaller than 4.5 then add a "G" (0<x<4.5) * If x is 4.5 or higher, but smaller than 9.5 then add a "B" (4.5<=x<9.5) * If x is 9.5 or higher then add a "R" (9.5 <=x) How could I solve that problem with Excel, MI or should I use MapBasic? Thank you for your help. With kind regards Christian christian cattaneo Bundesamt f�r Verkehr BAV Bollwerk 27/29 CH-3003 Bern e-mail: [EMAIL PROTECTED] oder [EMAIL PROTECTED] tel: +41 31 325 12 78 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11913 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11915 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11917
