Using IF Function

[Ridhi]

Hi...

I am trying to use a IF function where in it should display "Max"if the
value in the cell "D3" is less than 1000 ,2nd Condition- if the value in a
cell "D3"is greator than 1000 it should display"max7" ,3rd Condition if the
value is greator than 11000 then it should display"Max8".

I am trying to do it with IF function but alphabets are not accepected & the
cell is showing a "VALUE#" error.

Please help

 

[Dennis]

=IF(D3<1000,"Max",IF(D3>11000,"Max8","Max7"))

What should display if D3 = 1000 ?

 

[Ridhi]

The formula i used is
=if(D3<=1000,"Max")+IFAnd(D3>1000,D3<11000),"Max7")+IF(D3>11000,"Max8")

But using this the cell is showing "Value#"Error.

Thanks

 

[Ron Rosenfeld]

The formula i used is
=if(D3<=1000,"Max")+IFAnd(D3>1000,D3<11000),"Max7")+IF(D3>11000,"Max8")

But using this the cell is showing "Value#"Error.

Thanks

What made you think you could add IF statements that return text?

"+" is an arithmetic operator. If you want to concatenate, you use the "&"
operator, but you won't get the result you expect.

=IF(D3<=1000,"Max",IF(AND(D3>1000,D3<11000),"Max7",IF(D3>11000,"Max8")))

Also, Excel evaluates left to right, so your AND is superfluous:

=IF(D3<=1000,"Max",IF(D3<11000,"Max7",IF(D3>11000,"Max8")))
--ron