Thread: IF Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default IF Function

hi
try it this way....
=IF(D3<=1000,"max",IF(D3<=11000,"Max7",IF(D311000 ,"Max8")))

regards
FSt1

"Ridhi" wrote:

Please Help..i am using the below formula but "Value#"error is displayed.

=if(D3<=1000,"Max")+IFAnd(D31000,D3<11000),"Max7" )+IF(D311000,"Max8")

But if i used only any one condition like the 1st one
(=if(D3<=1000,"Max"))the fuction works perfectly.

Regards
Ridhi