Excel "IF" formula that contains both word and number criteria

[jordanbuchan359]

Hi there,

I'm new to the forum and looking for some help in relation a formula I am having a bit of difficulty with; the purpose of the formula is two separate things - The first part determines whether or not the inputted number is within parameters, the second searches for a specific word to determine whether or not the the test is applicable. I currently receive an #value! error.

My attempt:

=IF(AND(E67<1.26,E67>0.74),"Pass","Fail"),IF(COUNT(SEARCH({"Chocolate","Biscuit"},E7)),"N/A","")

Any help would be greatly appreciated.

* The first part of the formula works fine by itself.

[cbatrody]

How about the following?

=IF(COUNT(SEARCH({"Chocolate","Biscuit"},E7)),"N/A",IF(AND(E67<1.26,E67>0.74),"Pass","Fail"))

[TMS]

The first part of the formula works fine by itself.

Yes, it will. It is a self contained IF function with a condition and a True and a False outcome. Similarly, the second function.

If you want two independent answers in one cell, you could try:

Please Login or Register  to view this content.

Regards, TMS

[jordanbuchan359]

That Does work yes, however I would also like to add another piece of text:

Chocolate - Returns nothing (I'd like a blank cell)
Biscuit - Returns nothing (I'd like a blank cell)
Tea - Returns "N/A"

However, now the part that returns the pass / fail based on the parameters does not work

[TMS]

That Does work yes

What works? You've had two solutions offered. What does your formula look like now?

Regards, TMS