Macro IF,AND. How to?

[Maci3j]

Dear readers,

Im an amateur in making macros and I cant menage to make a valid macro for the fallowing case which will easy my work a lot. So may I ask you to give me an example of the formula from beginning to the end?What I'm searching is a formula for:

"Score" (is the name of the column) is located in cell H9 and the values (the scores) are located in a range (H10:H1577).

If the values in the range H10:H1577 are >=1 and <=10 then "Group1" should appear in the cell where i put the formula. But not a messagebox.

If the values in the range H10:H1577 are >=11 and <=30 then "Group2" should appear in the cell where i put the formula. But not a messagebox.

Thanks in advance

 

[par60056]

try the formula:
=if(And(H10>=1,H10<=10),"Group1",if(and(H10>=11,H10<=30),"Group2","Group3"))

If you have many more groups than this, you should probably make a little lookup table like:

0	Group0
1	Group1
11	Group2
31	Group3
51	Group4

<tbody>
</tbody>

=vlookup(H10,Groups!A1:B5,2)

 

[Maci3j]

This is exactly what I need. Thank you par60056 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!