Russ already gave you a formula to use IF your source data is in TEXT
format. If that is the case, then you have your solution. On the other hand,
if you are using the default numeric format for the source values, then
there is a problem with any entry that has 10 pounds. Excel can't
differentiate between a numeric 12.1 and 12.10 since they are the same
value.

If the source is numeric, then the formula would be this:
=INT(C1)*14+IF(AND(C1-INT(C1)>0,
(C1-INT(C1))<0.2),100*(C1-INT(C1)),10*(C1-INT(C1)))
However, this formula will not work for an entry that has 10 pounds - it
will treat it as one pound.

Peter
----------------------------------
[log in to unmask]

-----Original Message-----
Like this:

12.1
12.2
12.3
12.4
12.5
12.6
12.7
12.8
12.9
12.10
12.11
12.13
13

etc etc

Mick

             Do you want to signoff PCSOFT or just change to
                    Digest mode - visit our web site:
                   http://freepctech.com/pcsoft.shtml