Use of If function in multiple columns based on other multiple columns

[jainraunak]

Hi all,

I have 3 column in a spreadsheet as Xth marks, XII marks and graduation marks,
With each column, there is one more column about the score, whether the score is in cgpa or in percentage.

I need to filter the candidates those having 60 or more percentage throughout or cgpa 6.0 or more throughout



Can I do it via using If operator?? any other short method to apply for??

Thanks in advance.

 

[Special-K99]

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[becci.gott]

Can you add an extra column for filtering? You could add in a boolean formula that flags if the criteria are there.