Hi,

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

etc.

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?

Please help!