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 another sheet return text ,or if cell is greater than or equal to a cell referenced number on another sheet return text or cell is greater than or equal to number return text ..
I tried the IFS function, no way could I get it to work, did the IF nested thingy got it to work without inequalities but tried this
=IF(O6<'MENU LIST'!D3,"alpha",IF(AND(O6<'MENU LIST'!D4,O6>'MENU LIST'!D2),"beta",IF(AND(O6<'MENU LIST'!D5,O6>D3),"gamma",IF(O6>'MENU LIST'!D4,"DELTA"))))
and faled!
cheers
M
6 Replies
- 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
Rosanna, why don't you start separate conversation? That's a separate question.
Thank you
Hi,
This is the formula that may solve your problem:
Please open the attachment below to test the formula.
Hi Madeleine
The formula is correct, the problem is with the logical conditions ( which cell is bigger or small another cell, or not equal) you should be precise to get the correct value.
would you please upload your excel sheet if you still need help.thankyou, I'll try that
Madeleine
If you want to check for inequality, you have to use this comparative operator: <>
IF(O6<>'MENU LIST'!D3,"Alpha" ...
