If value betwenn 0% and 50% than yes
 

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/

If value betwenn 0% and 50% than yes
 

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/

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

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

If value betwenn 0% and 50% than yes
 

=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/

.

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

If value betwenn 0% and 50% than yes
 

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/

.