Pavement area

[Dman2900]

Ok, I am trying to make a equation in excel and I can not get it to work.....

I need this formula to work....

=(B5*B6)+((B7²)-((3.14*B7²)/4))+((B8²)-((3.14*B8²)/4))+(B11*B12)

Every time I put in the second B7² it will not recognize it as a cell and shows and error.....same with the B8²....and the B11 and B12 will not read either.......once it goes to the first B7² it has an error and will not read any more cells.....

Any suggestions?

Thanks in advance.....

 

[devonknows]

Hi,

If i am asusming you are trying to Square the Numbers so if B7 was 10 then the output would be 100 yes?

If you are trying to Square then the procedure would be:
=(B5*B6)+((B7^2)-((3.14*B7^2)/4))+((B8^2)-((3.14*B8^2)/4))+(B11*B12)

If all the above cells where the number 5 then your output would be 60.75

Instead of B8² you would use B8^2 (Shift & 6)

Regards

 

[Dman2900]

Yes, I am trying to square the numbers......

I used the formula you just gave me and it returned a answer of FALSE

B5 = 21.3
B6 = 20.0
B7 = 10.0
B8 = 20.0
B11 = 35.0
B12 = 2.0

I am trying to get area of pavement on an entrance......

Thanks for the help.....

 

[shg]

Try this:

=B5*B6 + B7^2*(1-3.14/4) + B8^2*(1-3.14/4) + B11*B12

It looks like B5 and B6 are the dimensions of one rectangle area, B11 and B12 are another, and B7 and B8 are squares with the inscribed circle removed.