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
"k f h" wrote:
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
|