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
