ExcelBanter - convert "less than" value from ppb to ppm

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - convert "less than" value from ppb to ppm (https://www.excelbanter.com/excel-discussion-misc-queries/250863-convert-less-than-value-ppb-ppm.html)

rlihle1

convert "less than" value from ppb to ppm

Need a formula to change values from parts per billion to parts per million,
but need to have formula to check for "less than" and complete conversion.

51 would be 0.051
<5 would be <0.005
THANKS

Fred Smith[_4_]

convert "less than" value from ppb to ppm

=if(left(a1,1)="<","<"&right(a1,len(a1)-1)/1000,a1/1000)

Regards,
Fred
"rlihle1" wrote in message
...
Need a formula to change values from parts per billion to parts per
million,
but need to have formula to check for "less than" and complete conversion.

51 would be 0.051
<5 would be <0.005
THANKS

Jacob Skaria

convert "less than" value from ppb to ppm

Try
=IF(N(A1),"",LEFT(A1,1))&IF(N(A1),A1/1000,MID(A1,2,99)/1000)

--
Jacob

"rlihle1" wrote:

Need a formula to change values from parts per billion to parts per million,
but need to have formula to check for "less than" and complete conversion.

51 would be 0.051
<5 would be <0.005
THANKS

All times are GMT +1. The time now is 05:58 PM.