Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Total newbie formula question

0

I've had to make a spreadsheet for work. Part of it looks like this:

Panel Size  Price/ea Weight/ea Total ft2 Price/ft2

3x8           $ 168.00         70           24         $ 7.00

3x9           $ 189.00         78           27          $ 7.00

3x10          $ 201.00         87          30          $ 6.70

I figured out the price/ft2 on a calculator. How would I figure it in a formula? I tried SUM=C2/E2 (the first row), but that didn't work. QUOTIENT doesn't seem to work either. I also need to average the price/ft2 for all the rows in a separate cell. I'm just learning this program for work, so please keep the answer as simple as possible.

Thank you!

exceldata-analysisformulas-functions
MS Office Version: 2016
posted by: Rita_Texas on Tue May 12, 2020 at 2:32 pm
Answer
Discuss

Answers

0

The four basic algebraic functions, add, subtract, multiply and divide are all written as you speak.

[add] = A1 + A2 
[subtract] = A1 - A2
[multiply] = A1 * A2
[divide] = A1 / A2

So assuming that your example is in a range A2:E4, you can work out the price per sqft. 

as = 168 / 24 
or = A2 / D2

It could also be = 168 / (3 * 8) which can't be transscribed using cell references because you have the size in a single cell. Consider using two columns for Width and Lenth to enable more calculations.
posted by: Variatus (rep: 4889) on Tue May 12, 2020 at 9:32 pm
Discuss
0

I created a simple spreadsheet attached to this post that should do what you are asking. I did split your panel size into 2 columns ... one for panel width (Col. A) and one for panel length (Col. B). The formula in Column E is: =sum(A2*B2) and will give you the square footage of the panel. The formula in Column F to figure the price per square foot is: =SUM(C2/E2). In cell G2 the formula: =AVERAGE(F:F) will give you the average price per square foot.

Hope this is what you are looking for.

posted by: Saluki73 on Tue May 12, 2020 at 10:13 pm
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login