IF function with various conditions

Rhon Alvarez

Member
Hi Team,

I need help with this one please.

I am having difficulty creating formulas for the above 8 hrs condition for i am getting the same result as that of 4 hrs to 8 hrs condition.

kindly take note that every entry should reflect only the highest Tier attained and will automatically disqualified on the lower tier.

Formulas only please for we cannot use VBA.

Rhon

Attachments

• 20 KB Views: 6

p45cal

Well-Known Member
In cell C2:
=IFERROR(INDEX({1,2,3;2,3,4;3,4,5},MATCH(B2,{0.65;0.68;0.7000001}),MATCH(A2,{0,4,8.0000001})),"")
copy down.

bosco_yip

Excel Ninja
Another option using If function only

In C2, formula copied down :

=IF(B2<0.65,"",IF(B2>0.7,3,IF(B2>0.67,2,1))+IF(A2>8,2,IF(A2>3.99,1,0)))

Excel Wizard

Active Member

=IF(B2>64%,2+(B2>67%)+(B2>70%)-(A2<4)+(A2>8),"")

Aytazaz

New Member
Dear I have a simple problem regarding IF formula, In a table I only want to pick the rows that meet my criteria (Lets say, Between Yes and No for a specific entry, I want to create a table of entries only having YES). The rows which were not meeting the criteria were left blank. How can I remove these blanks so that only the rows that meet the criteria appear in my table. Hope you have grasped my query. waiting for your reply. Please contact me on a y t a z a z a l i 1 2 3 @ g m a i l . c o m
(( Moderator note: It not wise give any email-address here. ))

Thanks

Last edited by a moderator:

Aytazaz
Moderator note: