Formulae

K

k f h

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
 
T

tjtjjtjt

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

k f h

Thanks tj for your quick response

kfh.


tjtjjtjt said:
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
Click to expand...
 
Top