Need special formula for data entry
Need special formula for data entry
(OP)
Hi,
please find the below image and do the needful to create special formula.

Thanks in advance.
Regards,
Ravi
please find the below image and do the needful to create special formula.

Thanks in advance.
Regards,
Ravi





RE: Need special formula for data entry
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Need special formula for data entry
Cheers
Greg Locock
New here? Try reading these, they might help FAQ731-376: Eng-Tips.com Forum Policies http://eng-tips.com/market.cfm?
RE: Need special formula for data entry
RE: Need special formula for data entry
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: Need special formula for data entry
If you know the answer, please help. No need to comment showing your highness.
RE: Need special formula for data entry
This site averages 2 student posts per week, because that's what some students would rather do.
Excel has string handling functions such as Left, Mid, Right for parsing strings. You can use the Find function to look for the ± character.
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: Need special formula for data entry
RE: Need special formula for data entry
What have you tried in either of these two threads?
What works or does not work?
Often if you explain what you tried and what results you observed, it can be helpful.
BTW, images are great for admiring. But if you want help, a worksheet is required. I won't waste my time trying to transcribe your picture.
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Need special formula for data entry
RE: Need special formula for data entry
For instance, just to get you started, Nominal could be...
=--LEFT($A2,FIND("±",$A2)-1)
...where A2 is the source cell.
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Need special formula for data entry
=LEFT(B13,FIND("±",B13)-1)
=SUBSTITUTE(B13,CONCATENATE(C13,"±"),"")
Thank you very much all for your support.
Regards,
Ravi
RE: Need special formula for data entry
=SUBSTITUTE(B13,CONCATENATE(C13,"±"),"")
about?
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Need special formula for data entry
RE: Need special formula for data entry
> Your columns suggest that you need to handle the case where + and - tolerances are different, which means that you need to handle something like mm.mm + pp.pp - nn.nn
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: Need special formula for data entry
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Need special formula for data entry
Nominal: =--LEFT(Display,FIND("±",Display)-1)
Plus tol: =--RIGHT(Display,LEN(Display)-FIND("±",Display))
Minus tol: =-RIGHT(Display,LEN(Display)-FIND("±",Display))
max value: =Nominal+Plus_tol
min value: =Nominal+Minus_tol
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Need special formula for data entry
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: Need special formula for data entry
The other stuff is multiple cells, and I have no idea how the requirement will be stated. He's all over the place.
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Need special formula for data entry
As I am Design engineer and very new to excel, took the help of this forum.
Thanks for the support and I got solution.
I will continue the next plan converting these formulae to userform by help of colleagues here.
Once again thank you very much eng-tips and supporters.
Regards,
Ravi.