Formulae

[Guest]

Hi All,

I need to reduce a figure by 5% and increase one by £1.50 how do I put this
into a forulae.

Thanks,

kfh

 

[Guest]

If I understand your questions correctly:
=YourFigure*.95 for 95% of a number.
Example
=100*.95 will return 95.

For the second part you want to add 1.50 pounds?
=YourNumber+1.5
Example:
=3+1.5 will return 4.5
The pound symbol should probably be aplied as formatting rather than typed.
Format | Cells | Number. Pick either Currency or Accounting and set the
appropriate monetary symbol.

tj

 

[Guest]

Thanks tj for your quick response

kfh.

If I understand your questions correctly:
=YourFigure*.95 for 95% of a number.
Example
=100*.95 will return 95.

For the second part you want to add 1.50 pounds?
=YourNumber+1.5
Example:
=3+1.5 will return 4.5
The pound symbol should probably be aplied as formatting rather than typed.
Format | Cells | Number. Pick either Currency or Accounting and set the
appropriate monetary symbol.

tj