In A 1 = 0,0003
Result in B1= 3 ,c1 =4
D1 = 3 x 10^-4
If A2= 0,0028
B1= 2,8 ,c1= 3 ,d1 = 2,8 ^-3
I want to change decimal to power
What is formula ??
In A 1 = 0,0003
Result in B1= 3 ,c1 =4
D1 = 3 x 10^-4
If A2= 0,0028
B1= 2,8 ,c1= 3 ,d1 = 2,8 ^-3
I want to change decimal to power
What is formula ??
"ThankyouFor Attention * And Your Help!!"
So the input is in Column A, and you want to determine by formulas the values in Columns B, C & D?
Yes maybe in b1 using int,or in c1 using round in d1 using power
May the below
=IF(MOD(A1,1)>0,A1*10^LEN(INT(1/A1))&" X 10^-"&LEN(INT(1/A1)),A1)
hope some one come with better formula
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
thank very match
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks