Forum Discussion
Using multiple IF functions with, AND but I want to include inequalities
Hi I'm new to this [and very excel 'light' and would be grateful for any help offered. I want to create a formula that will return If cell is greater than or equal to a cell referenced number on an...
hello friends, I have a problem for you. I have to compare two lines of 20 cells containing letters.If the cells have the same content, the same letter, the system must count 5 if they have different letter, they must count zero, if a cell is empty it has to count 1. Can I use the Db.conta.se function? But I'm mistaken #Value and I can not fix the problem. do you help me? thank you
Hi,
This is the formula that may solve your problem:
Please open the attachment below to test the formula.