from what kind of a source data?
I am working on a school assignment trying to estimate how much paint will cost base on the sq ft. Example:
Room: F. Room 25' Length 15' Width and Ceiling Height 12. The SF total is 1335, but I cannot figure the formula.
you gotta sum the areas of the walls.
for this room
=(2*12*15)+(2*12*25) is the math formula
room a
height 12
Length 15
width 25
960
=2*(B2*B3+B2*B4) is how you find 960 sq. whatever
this is a math problem, not an excel issue
I do understand the math, but how come the Prof. is asking for a formula.
So if the answer is 1335 you are including the ceiling - for total square footage
=(L+W)*2*H+(L*W)
If you have L, W and H in cells you can replace those with cell references
Audere est facere
Thank you very much.![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks