I hope this is in the right post ...
I am trying to work out a simple spread sheet for pricing, based on AREA, like this:
If it costs $50 to paint 1m2 (one meter sq) then:
1m x 1m x $50 : $50
2m x 2m x $50 : $200
1.8m x 1.2m x $50 : $108
This is all good, except when I go into decimals ...
0.5m x 0.5m x $50 : $12.5 (it should be $25!)
0.9m x 0.6m x $50 : $27 (it should be $54!)
Why do I always get half of the 'real' value?