Thread: If value betwenn 0% and 50% than yes
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default If value betwenn 0% and 50% than yes
On Fri, 24 Oct 2003 07:35:51 -0400, 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



=IF(AND(A1,A1<50%),"Yes","Now")

(0% and 50% will both -- "Now" as they are not "between" as you specified)


--ron
Reply With QuoteReply With Quote