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

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

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

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

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

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