ExcelBanter - IF function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF function (https://www.excelbanter.com/excel-discussion-misc-queries/137750-if-function.html)

ferde

IF function

Is it possible to ask the following

=if(B2=300 and <=349,"excellent",if(B2=500 and <=550,"fair"))

Please help

Ferde

Mike

IF function

Try this
=IF(AND(B2=300,B2<=349),"Excellent",IF(AND(B2=50 0,B2<=550),"Fair","Unknown"))

"ferde" wrote:

Is it possible to ask the following

=if(B2=300 and <=349,"excellent",if(B2=500 and <=550,"fair"))

Please help

Ferde

ferde

IF function

This works GREAT ....
Thank you Mike

"Mike" wrote:

Try this
=IF(AND(B2=300,B2<=349),"Excellent",IF(AND(B2=50 0,B2<=550),"Fair","Unknown"))

"ferde" wrote:

Is it possible to ask the following

=if(B2=300 and <=349,"excellent",if(B2=500 and <=550,"fair"))

Please help

Ferde

Mike

IF function

Your welcome

"ferde" wrote:

This works GREAT ....
Thank you Mike

"Mike" wrote:

Try this
=IF(AND(B2=300,B2<=349),"Excellent",IF(AND(B2=50 0,B2<=550),"Fair","Unknown"))

"ferde" wrote:

Is it possible to ask the following

=if(B2=300 and <=349,"excellent",if(B2=500 and <=550,"fair"))

Please help

Ferde

All times are GMT +1. The time now is 03:08 PM.