Rounding to nearest 1/16" - Excel Help Forum
Dec 18, 2007 · Its pythagorean theorem. It work but I want to round my answer off to the nearest 1/16" (closest up or down). I typed in this formula: =mround(sqrt(cell^2+cell^2),0.0625) It doesn't work obviously. But say my answer is 12.078125, I want it to round to 12.0625. Say my answer is 12.109375, I want it to round to 12.125.
Incentive Excel Calculation...
Dec 28, 2024 · I would appreciate your assistance in developing the incentive calculation formula. Attached Files Incentive_Calculation (3).xlsx (10.1 KB, 6 views) Download
List names in a rows - Excel Help Forum
Dec 15, 2024 · Join Date 07-15-2010 Location The Great City of Manchester, NW England ;-) MS-Off Ver MSO 2007,2010,365 Posts 47,330
IF statement with blank cells - Excel Help Forum
Dec 31, 2024 · I feel like I'm generally pretty good with formulas but I'm a bit stumped here. Thinking I need to use an IF statement, but can't fully make it work. What I'm looking to do is have the formula in column AD. If there is a value in AC I would like that to return. If there is not a value in AC I would like AA to return.
Averaging Wind Directions - Excel Help Forum
Mar 15, 2013 · The resulting average speed and direction are calculated from the Pythagorean Theorem and "arctan(u/v)," respectively. Those both seem peculiar to me. The second seems reasonable as to direction, but the average speed should be RMS.
Remove Line Through Uncalculated Cells - Excel Help Forum
Nov 10, 2024 · Join Date 06-09-2014 Location USA MS-Off Ver 365 Version 2409 Posts 2,789
Account Status with Payments Formulas - Excel Help Forum
Aug 16, 2022 · Hello, When an Invoice is paid in full how can the Status column formula show that it is "Paid". If it is not paid in full with a payment it should remain with the conditions: Account is not paid and less than or equal to 30 days old "Current" Account is not paid and past 30 days "Past Due" Account is paid "Paid" In the case on the sheet I highlighted in orange Invoice 102.
When dragging a formula, how to make it go opposite direction?
Join Date 03-07-2014 Location 640932326656 MS-Off Ver excel 2010 Posts 20
Use InStr function in formula? - Excel Help Forum
Feb 2, 2006 · Use SEARCH or FIND. Help will give details.--HTH Bob Phillips (remove nothere from the email address if mailing direct)
Formula to determine which values Contra each Other [SOLVED]
Jul 5, 2021 · I have a formula to contra Debit and Credit Values in Col, H by returning a true of false (these contra entries will sum to zero) However, if there are 2 debit amounts for e.g. 100 each and one credit for -100, then the formula will return "True" for all 3 I need the formula to be amended to return "True" only for items that Contra out in Col H i.e match the debit or credit …