| 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
=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/ . |
|
#6
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 |
|
#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 | |||
![chrismania[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
