INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • 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.

Jobs

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

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.
If you know the answer, please help. No need to comment showing your highness.

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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

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,"±"),"")
about?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need special formula for data entry

He's just asking about THIS one thing.

The other stuff is multiple cells, and I have no idea how the requirement will be stated. He's all over the place.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

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.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources


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:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close