| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert numbers to date: "586" to read "May 1986" | Excel Worksheet Functions | |||
| any formula to convert numbers in word form, e.g. "2" as "Two"? | Excel Worksheet Functions | |||
| how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
| convert "15000" to "Fifteen thousand" in excel cell? | Excel Worksheet Functions | |||
| can we convert "2 days 16 hrs" to " 64hrs" using excel functions | Excel Worksheet Functions | |||
Linear Mode
