Formulae
 

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

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

Thanks tj for your quick response

kfh.


"tjtjjtjt" wrote:

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