INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Are you an
Engineering professional?
Join Eng-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

#### Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

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

Regards,
Ravi

### RE: Need special formula for data entry

Assuming you want something more complicated than simple + and - formulas, it isn't clear to me what you want to do.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

### RE: Need special formula for data entry

(OP)
I want to print the values before + or minus symbol and after + or - symbol in next 2 columns.

### RE: Need special formula for data entry

(OP)
haha, if homework, why should I post, I would have asked my teacher.

### RE: Need special formula for data entry

"if homework, why should I post"

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

I often use custom formatting rather than concatenation - it keeps the cell contents to numeric values that can be used elsewhere.

### RE: Need special formula for data entry

You posted thread770-420991: Macro to get input box with required values, very similar. No resolution there???

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

I guess that you could do this with an ordinary formula. No need to use a special one.

### RE: Need special formula for data entry

Yes, just native Excel functions like, LEFT(), RIGHT(), FIND(), LEN()

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

(OP)
Thank you Skipvought, I got some formula for the same.
=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

What is
=SUBSTITUTE(B13,CONCATENATE(C13,"±"),"")

Skip,

Just traded in my OLD subtlety...
for a NUance!

### RE: Need special formula for data entry

(OP)
To print value next to plus or minus sign.

### RE: Need special formula for data entry

> Isn't that what you're starting with?
> 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

But I feel sorry for you, so here's a solution using Named Ranges.

Display	Nominal	Plus tol	Minus tol	max value	min value
20±0.01	20	0.01    	-0.01   	20.01   	19.99


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

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

(OP)
Hi SkipVought,
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.

#### Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

#### Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Close Box

# Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!