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
|