Simple math formula

[nur2544]

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.

[Jakobshavn]

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)

[nur2544]

hi Jakobshavn,Excellent salvation, thanks for you time...

[nur2544]

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

[nur2544]

got solution like :

Please Login or Register  to view this content.