If value betwenn 0% and 50% than yes
On Fri, 24 Oct 2003 08:18:18 -0400, Ron Rosenfeld
wrote:
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
typo: Should have been =IF(AND(A10,A1<50%),1,0)
--ron
|