CODEWITHSUNDEEP
multiple-conditions
user3494361
user3494361

Reputation: 13

Multiple Conditions In Excel

I entered the below formula into excel. When I copy the formula down for the rest of my sheet, it gives the "eligible" value to all fields even when the J field has no data to pull from. What am I missing?

=IF(J3<=40,"Eligible",IF(AND(J3<=30, J3>=39.99), "Particially","No"))

Upvotes: 1

Views: 52

Answers (2)

John Powell
John Powell

Reputation: 12581

Blank is interpreted as zero, so J<=40 will be true. You probably need to put an IsNumber check in there too.

=IF(AND(J3<=40,ISNUMBER(J3)),"Eligible",....

EDIT: based on your comment, you can simplify this by reversing the logic, and you don't need an and clause.

=IF(J1<30,"no",IF(J1<40,"partial","eligible"))

Upvotes: 2

Lukas2
Lukas2

Reputation: 320

I think logic is wrong. Try this (included remark by John Barça):

=IF(ISNUMBER(J3),IF(J3<30,"Eligible",IF(AND(3<=39.99,J3=30),"Partially","no")),"Not a number")

Or please describe what you want to get.

Upvotes: 0

Related Questions