Using IF Function

  • Thread starter Thread starter Ridhi
  • Start date Start date
R

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
 
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
 
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
Click to expand...

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
 
Back
Top