Microsoft excel help - 10 pts for solving

[Squirrel]

Word up guys

I have a huge table in excel - all down colum AH there is a figure, just a generic formula, the numbers are all between 0.00 and 1.00 and to 2 decimal places (if this is relevant I dunno)

Now what I want is to have a formula in the column next to it, AI, that reads the figure in column AH and gives me an output from 3 choices....

..if the figure is greater than 0.28 I want it to say GOOD
..if the figure is between 0.24 and 0.28 inclusive I want it to say NEUTRAL
..if the figure is less than 0.48 I want it to say BAD

I know about IF formulas I just can't quite get it to give me a choice of all 3 outcomes. Whats the exact formula that I need to put in column AI to make this happen?

I'm actually using openoffice not excel, but apart from using a semi-colon instead of a comma its pretty much the same (I think)

Cheers dudes - 10 pts to first person who solves this for me

[Squirrel]

Edited - the numbers in the column I want to read are all between 0.00 and 1.00

[rookie]

if the figure is less than 0.48 I want it to say BAD - do you mean less than .24 instead ?

If yes, IF(AH1>0.28,"GOOD",IF(AH1>=0.24,"NEUTRAL ","BAD")) (MSEXCEL)

[stats13]

if the figure is less than 0.48 I want it to say BAD - do you mean less than .24 instead ?

If yes, IF(AH>0.28,"GOOD",IF(AH>=0.24,"NEUTRAL", "BAD")) (MSEXCEL)

actually you want it to say this:

=IF(AH>0.28,"GOOD",IF(AH>=0.24,"NEUTRAL" ,"BAD"))

[keyboarding]

Nevermind, other people posted it.

[Squirrel]

Great work, feeling generous so 10 pts to the originally solver and also 10 pts for the correction.

Cheers dudes

[stats13]

heh, i was joking, but thanks!

[MilfDriller]

stats, I love your avatar of a true intellectual. good stuff