• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IF function with various conditions

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.

Please find attached file and do edit/add as necessary.

Formulas only please for we cannot use VBA.

Thanks in advance,

Rhon

77530
 

Attachments

  • Raffle Template.xlsx
    20 KB · Views: 6
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.
 
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:
You should open a new thread based Your case.
... as You've read from Forum Rules
This thread belongs to other member.
 
Back
Top