Mixed data format into single format

[abelmgeb]

Hi:

I have data that look like this (Current Data); and I want to change it to a format like the next column("Needed"):
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"][TABLE="width: 128"]
<tbody>[TR]
[TD="width: 64"]Current Data[/TD]
[TD="width: 64"]Needed[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]0.082[/TD]
[TD="align: right"]8.2[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]7.2[/TD]
[TD="align: right"]7.2[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]0.065[/TD]
[TD="align: right"]6.5[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]7.2[/TD]
[TD="align: right"]7.2[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]0.066[/TD]
[TD="align: right"]6.6[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]6[/TD]
[TD="align: right"]6.0[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]


Just to give a background, this is a lab value; and different lab companies send us data in two formats; and I need to have the same format in order to do further analysis and calculations to the values.

Thanks for your help.

abelmgeb

 

[Noodleski]

Hm, assuming there are no 'correct' values under 1

IF(A2<1,A2*100,A2)

dragged down.

 

[Rick Rothstein]

Here is another formulas that should also work...

=A2*100^(A2<1)

 

[abelmgeb]

Here is another formulas that should also work...

=A2*100^(A2<1)

Thanks for your quick response. It works well.

Appreciated

 

[Rick Rothstein]

Thanks for your quick response. It works well.

Appreciated

You are welcome. Just pointing out, in case you missed it, that you have another response in Message #2 as well.