LinkBack URL
About LinkBacks
A1=39.7
B1=38.6 - 68.9
Here, Cell A1 contains single data but B1 data is together & that is separated by dash, so from here I need to solve below calculations
Please Login or Register to view this content.
A1=39.7
B1=38.6 - 68.9
Here, Cell A1 contains single data but B1 data is together & that is separated by dash, so from here I need to solve below calculations
Please Login or Register to view this content.
In C1 thru F1 enter:
=--MID(B1,1,FIND("-",B1)-1)-RIGHT(B1,4)
=A1-RIGHT(B1,4)
=C1/RIGHT(B1,4)
=D1/RIGHT(B1,4)
Gary's Student
hi Jakobshavn,Excellent salvation, thanks for you time...
hi Jakobshavn , need little bit modified your formula. here RIGHT(B1,4) this logic is not applicable for all time as the data change all time
C1=20.31-125.65= -105.34
got solution like :
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks