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
|