# Simple math formula

1. ## Simple math formula

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.``

2. ## Re: Simple math formula

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)

3. ## Re: Simple math formula

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

4. ## Re: Simple math formula

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

5. ## Re: Simple math formula

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

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1