IF Function

R

Ridhi

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

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

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

Regards
Ridhi
 
F

FSt1

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

regards
FSt1
 
P

paul.robinson

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
 
B

Bob Phillips

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


--
HTH

Bob

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

Ridhi

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

[email protected] said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using IF Function 3
if then else 2
macro hangs if no data is found 6
Search function in Excel 5
Print only the used sheets in all open files 2
Save As and new workbook new name used in existing code 8
show cell reference as text 5
#VALUE! error 1

Top