If statement

[karobonas]

Hi,

I have a spreadsheet which has various calculations. I would like excel to display a numeric percentage if a calculated value is greater than a certain no. If it is less than a certain number I would like it display a different value.

i.e. if total is greater than or equal to 0 but less than 1.9 then excel will display 10%
and
if total is greater than or equal to 2 but less than 2.9 then excel will display 15%
and finally
if total is greater than or equal to 3 but less than 4 the excel will display 30%

Any help is much appreciated,

Kind Regards,

Karo