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 …

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 …

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 …

Mar 15, 2013 · The vectors are then broken down into their u and v components. All u and v components are then averaged separately. The resulting average speed and direction are …

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 …

May 18, 2025 · Hi, I need help with a formula to identify / match multiple contra entries in my spreadsheet. I've tried using a formula but it only identifies the first set of contra entries as …

6 days ago · Hi - I'm using the following formula to count unique project codes within a defined date period and it's causing havoc with my laptop and constantly crashing excel - can anyone …

Jun 21, 2024 · Re: Font in formula bar I noticed that the font had changed in the formula bar last week, and I guessed that it must have been some update to Excel that MS deemed to be …

Dec 12, 2019 · Adding "if blank" statement to an existing VLOOKUP formula By kala_way in forum Excel General Replies: 4 Last Post: 01-27-2012, 10:57 PM