Dec 1, 2009 · Re: Pythagoras Martin, sides of a triangle might be called "O", "H" and "A" when in reference to a Sine/Cosine/Tangent formula (SOH-CAH-TOA), however the Pythagorean Theorem is …

Dec 18, 2007 · I have a function right now that goes like this: =sqrt (cell^2+cell^2) Its pythagorean theorem. It work but I want to round my answer off to the nearest 1/16" (closest up or down).

Nov 30, 2020 · Re: Sort by Latitude and Longitude As the Location ID's would represent points then I would think we could utilize the Pythagorean theorem to find the relative distance between them. In …

May 29, 2025 · Re: Formula to exclude particular results / cells Hi, It's a totally different question. I'm not asking about weighted answers. AliGW, ignore the task that is out of 30 - that result goes …

Oct 22, 2019 · Re: Additional spacing within text string in formula bar Glad to help. I still can't figure out how it's getting there in the first place, and generally addressing root causes is better than cleaning …

Dec 22, 2025 · So what I was wondering is, is there a way to make the excel formula dismiss/ignore the characters after "Transfer Data" and work the formula correctly despite the source file name has …

Dec 21, 2025 · Re: Copying a formula from one notebook to another Method 1: The "Text Toggle" (Best for single formulas) This method prevents the spreadsheet from recognizing the formula as a "live" …

Apr 27, 2025 · Re: Formula to Ignore Non-Numerical Values You can use the ISNUMBER () function. As advised in the yellow banner at the top of this page, providing a sample workbook is a good idea. …

Dec 18, 2025 · Re: How do I change a macro to a formula Hint: Trailing space in sheet name: You have "SUMMARY " (with a space). Check if the actual sheet name is "SUMMARY" or "SUMMARY ".

Jun 20, 2016 · Re: Slope Percentage This would be a simple problem if you could just provide a picture or diagram. It's geometry/trig, and more specifically there will be some application of the Pythagorean …