Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 decimal cell
Is it possible to get 2 decimal cell using IF or any formula?
for example if cell A1 has or is "abc", cell A2 should be 2 decimal. Thanks. Mukesh |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 decimal cell
Try this from VBE immediate window..
If Range("A1") = "abc" Then Range("A2").NumberFormat = "0.00" If this post helps click Yes --------------- Jacob Skaria "Mukesh" wrote: Is it possible to get 2 decimal cell using IF or any formula? for example if cell A1 has or is "abc", cell A2 should be 2 decimal. Thanks. Mukesh |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 decimal cell
Suppose you have
A1 = abc B1 = 1.678 Enter this formula in A2 =IF(A1="abc",ROUND(B1,2),B1) If this post helps click Yes --------------- Jacob Skaria "Mukesh" wrote: Is it possible to get 2 decimal cell using IF or any formula? for example if cell A1 has or is "abc", cell A2 should be 2 decimal. Thanks. Mukesh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
Batch converting CSV files from comma-decimal to period-decimal | Excel Discussion (Misc queries) | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
Show a time from one calculated cell as a decimal in another cell. | Excel Worksheet Functions |