I'm using Excel and want to know how to reduce a given figure eg £150 by say 22%. What formular do I need. Ta.

Answer 1

150 x 22/100 = 33 In Excel I think it would actually be 150*22/100
The * is usually used to multiply.

Answer 2

Say your 150 is in cell A1 and you want your result in A2

In A2 type exactly this: =A1*(1-22%) including the = sign
Then hit Enter

Or you can enter 22% in A2 and in A3 type exactly this: =A1*(1-A2) again including the = sign
Then hit Enter

Enjoy!

Answer 3

Do you mean something like this?

=PRODUCT(A1:A2), where:

A1 is variable 1
A2 is variable 2