| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF STATEMENT Range
Hello, I am trying to put a range in an if statement '0-50', how do I do this
please? It's as follows: =IF(AI7 'is between 1:50',(AB7*AI7/100),AI7) Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF STATEMENT Range
Use this:
=IF(and(AI71,AI7<50),(AB7*AI7/100),AI7) Hope this helps. "Bee" wrote: Hello, I am trying to put a range in an if statement '0-50', how do I do this please? It's as follows: =IF(AI7 'is between 1:50',(AB7*AI7/100),AI7) Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF STATEMENT Range
Thanks for that, perfect. Another question, do you know how to do a
conditional format for a cell that is <50 to display as % and if 50 show just a decimal number. Thanks again. "BriSwy" wrote: Use this: =IF(and(AI71,AI7<50),(AB7*AI7/100),AI7) Hope this helps. "Bee" wrote: Hello, I am trying to put a range in an if statement '0-50', how do I do this please? It's as follows: =IF(AI7 'is between 1:50',(AB7*AI7/100),AI7) Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF STATEMENT Range
You have a reply at your other post.
Bee wrote: Thanks for that, perfect. Another question, do you know how to do a conditional format for a cell that is <50 to display as % and if 50 show just a decimal number. Thanks again. "BriSwy" wrote: Use this: =IF(and(AI71,AI7<50),(AB7*AI7/100),AI7) Hope this helps. "Bee" wrote: Hello, I am trying to put a range in an if statement '0-50', how do I do this please? It's as follows: =IF(AI7 'is between 1:50',(AB7*AI7/100),AI7) Thanks -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF STATEMENT Range
=if(and(ai71,ai7<50),(ab7*ai7)/100,ai7)
But I'm not sure what happens at 1 and 50. You may want: =if(and(ai7=1,ai7<=50),(ab7*ai7)/100,ai7) Bee wrote: Hello, I am trying to put a range in an if statement '0-50', how do I do this please? It's as follows: =IF(AI7 'is between 1:50',(AB7*AI7/100),AI7) Thanks -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF STATEMENT Range
Try this:
=IF(AND(AI7=1,AI7<=50),AB7*AI7/100,AI7) -- Biff Microsoft Excel MVP "Bee" wrote in message ... Hello, I am trying to put a range in an if statement '0-50', how do I do this please? It's as follows: =IF(AI7 'is between 1:50',(AB7*AI7/100),AI7) Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| range in an IF statement | Excel Worksheet Functions | |||
| IF statement with a range | Excel Worksheet Functions | |||
| Use a range name in VB with IF Then Else statement | Excel Discussion (Misc queries) | |||
| if statement with date range | Excel Worksheet Functions | |||
| IF Statement with a range | Excel Worksheet Functions | |||
Hybrid Mode
