| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If formula based on digits?
Is there anyway to pull out certain digits based on rounding?
In A1...143.265 So my if would be =if(A1<0,A1,"") However I only want the 2 digits after the decimal to pull. I know I can do a middle, or right formula but how would this work if I had several rows some with 1.199 and others with 145.258? Please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA write macro change column with 3 number digits to 4 digits the | Excel Discussion (Misc queries) | |||
| Checking status of issues based on first two digits of a field | Excel Discussion (Misc queries) | |||
| Validation based on digits in the middle of a string | Excel Programming | |||
| data filtering based on last two digits of large number | Excel Worksheet Functions | |||
| How do I sort numbers based on last two digits? | Excel Programming | |||
Threaded Mode
