Try something like

=IF(AND(A1=0,A1<=0.5),"yes","no")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"chrismania" wrote in 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/