If statement

**karobonas** · 12-02-2010, 10:54 AM

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

**NBVC** · 12-02-2010, 11:14 AM

Perhaps?

=LOOKUP(A1,{0,2,3,4},{0.1,0.15,0.3,""})

where A1 contains total.

you can replace the "" with a number if you want a value to appear if A1 is greater than or equal to 4.

**karobonas** · 12-02-2010, 11:25 AM

Hi,

Thanks for your pompt response....

It seems to work fine for any value over 4, please see attached jpeg to display my results. The other values however do not seem to work. What changes do you propose I make to rectify?

Thanks again for your help.