Not quite Patrick - you forgot about negative numbers.
Your solution should read
=IF(AND(A1=0,A1<=0.5),"yes","no")
as this is a programming forum
If Range("A1").Value <= 0.5 AND Range("A1").Value = 0 then
Range("A2").Value = "yes"
else
Range("A2").Value = "no"
end if
Also - the OP did use "yes" and "now".
Chrissy.
"Patrick Molloy" wrote in message ...
=IF(A1<=.5,"yes","no")
as this is a programming forum
If Range("A1").Value <= 0.5 then
Range("A2").Value = "yes"
else
Range("A2").Value = "no"
end if
Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
Hi guys
what is the formule for this problem
If the value of a cell is between 0% and 50% than yes
else now
Thanks
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/
.