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

What should display if D3 = 1000 ?

"Ridhi" wrote:

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