View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rlihle1 rlihle1 is offline
external usenet poster
 
Posts: 1
Default 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