Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
database extract having 3 common cell betwenn sheets | Excel Worksheet Functions |