Thread: If value betwenn 0% and 50% than yes
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Chrissy[_5_] Chrissy[_5_] is offline
external usenet poster
  
Posts: 33
Default If value betwenn 0% and 50% than yes
=IF(A1=0,IF(A1<=0.5,"yes","now"),"now")


Chrissy.


chrismania wrote
Hi guys
what is the formule for this problem
If the value of a cell is between 0% and 50% than yes else now


Reply With QuoteReply With Quote