## 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

in either of these two threads?What have you tried

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

I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg

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