View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ridhi Ridhi is offline
external usenet poster
 
Posts: 22
Default Using IF Function

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