There is a contradiction here, first you say if 10 then set it to 0.5,
then you say if 10 then set to 1. Which should it be?


--
__________________________________
HTH

Bob

"Kimmon" wrote in message
...
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?