foot

Suppose I have a table like the one below. As it stand now, the data is in D6:G11. I want to define a dynamic named range ("Table") that is, at the moment, D5:G11. If I add a row anywhere between 5 and 12 or a column anywhere between C and H, I want Table to automatically expand. <tbody> R/C C...

This is probably a simple fix, but I'm really new to Power Query and can't find an answer. I'm trying to compare square footage between two systems, but want to ignore any potential rounding differences less than -10 or greater than +10. My original formula was [#"Sqaure Foot A"] = [#"Square...

This is a complicated question to ask and I am not sure exactly how to ask it. I am attempting to make a pipe sizing tool to speed up one of my work processes. The procedure is pretty straight forward. Do some math to figure out GPM going to drain (done elsewhere) and then look up the pipe...

Is there a way to ROUNDUP in increments? For example, if A2 is 74 and I wanted the adjacent cell, A3, to round A2 to the closest foot, how would I do it?

Hi, I am brand new to this forum and not sure where to post this so forgive me if i did it wrong. I need help with a formula for a rate card for my job. I need Excel to calculate dollar amounts based on footages. The criteria are listed below. I have tried everything I know based on my limited...