Percentages

[DanielBellfield]

Hi i need to work out a given percentage of a cell.

For example:

100

10% of £100 = £10(display in cell)

any formula ideas?

 

[VoG]

Try like this

=A1*10%

 

[DanielBellfield]

Works a treat thanks!

Now can you help me work out a square meterage of 2 cells and * it by x amount?

Please?

 

[VoG]

Something like

=A1*B1*5

Change 5 to your value for x.

 

[DanielBellfield]

It producing a figure thats way to high... i needs to work out a standard cost + £5 per square meter. The difference is the figure that needs to be displayed.

 

[DanielBellfield]

Nope nevermind i needed to convert values for mm to mtr so its fine now... thanks for your help!