TNVC: NEW and Exclusive Filmed SuperGain (FSG) Image Intensifier Tubes & Chimera Pano Giveaway!!

[ARCHIVED THREAD] - Help with Excel Formula

Posted: 5/9/2016 12:18:08 AM EDT

Hey,
I need help creating an excel formula, I've been at it for a bit now and can't figure it out. What I'm trying to do is create a formula that will give me the range of numbers that is =/- 10% of a target number i.e. cell D2 is 22 and I want E2 to display 19.8-24.2. Is this even possible?
Thanks guys,
Bobby

Posted: 5/9/2016 12:30:39 AM EDT

[#1]

Have you tried using cell "e"as the low and cell "f" as the high? Make them small cells. I'll ask the wife in the morning. She speaks geek when it comes to excel.

Posted: 5/9/2016 1:19:10 AM EDT

[#2]

Yah, I that's actually how I have it now, just though there might be a way to make it neater/cleaner.

Posted: 5/9/2016 2:13:35 AM EDT

[#3]

Posted: 5/9/2016 11:34:05 AM EDT

[#4]

Quote History

Quoted:
http://www.ar15.com/media/viewFile.html?i=88154

View Quote

Stealing from the above:

=CONCATENATE(TEXT((D22*0.9),"0.0")&" - "&(TEXT((+D22*1.1),"0,0")))

=CONCATENATE(TEXT((D22*0.9),"00.0")&" - "&(TEXT((+D22*1.1),"00.0")))

ETA: Formats the results correctly.

[ARCHIVED THREAD] - Help with Excel Formula

Warning

Confirm Action

[ARCHIVED THREAD] - Help with Excel Formula

[ARCHIVED THREAD] - Help with Excel Formula