IF Function
 

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

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

IF Function
 

Hi
You probably want

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

no need to use the AND bit as <=1000 will be checked first and
checking between 1000 and 11000 will happen by default. Also no need
to check if value is 11000 as you have already checked <11000. You
might want to change <1000 or <11000 to <=.

regards
Paul
On Jun 3, 12:21*pm, 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

IF Function
 

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


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Ridhi" wrote in message
...
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

IF Function
 

that is also not working out....

"FSt1" wrote:

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

IF Function
 

Thanks sooo much ..it worked..thanks a tone

" wrote:

Hi
You probably want

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

no need to use the AND bit as <=1000 will be checked first and
checking between 1000 and 11000 will happen by default. Also no need
to check if value is 11000 as you have already checked <11000. You
might want to change <1000 or <11000 to <=.

regards
Paul
On Jun 3, 12:21 pm, 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