try this

=IF(B2<=5,0.5,IF(B2=10,1))

Does this do what you want?
--

Thank You

cheers,

========================
please click the Yes button if this help
========================






"Kimmon" wrote:

PLEASE help, I need to create a Macro urgent and don't know how:

QUESTION:

If cell x <5 or 10 x = 0.5
If cell x 10 x = 1

My attempt:

=IF(B1<5,"0.5",IF(B110,"0.5",IF(B110,"1")))

It doesn't look right?