Check a series of cells with IF function

[DTYS]

Dear Kind Experts,
I need help, appreciate your kind assistance.

Target cell is C18.
First I need to check if a cell D12 contain the words "Ribbon Tape Sheet", if True than do the below 2nd check, if False just ignore/blank.
Secondly if I wants to check a series of cells, example C16 to F16 (or more C16 to M16), whether their value is less than 320 (<320). If any of the cells is less than 320, if True to list a word "Warning", if False will be blank.

How should my formula be? Attached is the sample XL.

Thank you!

sample xl.jpg

[shukla.ankur281190]

Hi DTYs,

It will be better if you can upload a sample XL with desired result.

[DTYS]

Hi DTYs,

It will be better if you can upload a sample XL with desired result.

Hi Shukla,
Ok, I have revised and updated my above initial post. Thanks.

[salim ali]

See this file

[shukla.ankur281190]

Hi Shukla,
Ok, I have revised and updated my above initial post. Thanks.

Try this.

C18=IF(D12="Ribbon Tape Sheet","",IF(OR(INDEX(C16:H16<320,)),"WARNING",""))

But you have merged cells which will be become an issue with above formula.

[DTYS]

Try this.

C18=IF(D12="Ribbon Tape Sheet","",IF(OR(INDEX(C16:H16<320,)),"WARNING",""))

But you have merged cells which will be become an issue with above formula.

Hi Shukla,
Tried, but it does not work. Thanks.

[DTYS]

See this file

Hi Salim,
Thanks.
Firstly, I need/prefer the 2x checking or formula to be in a single target cell.

Secondly, test your XL, the formula unable to detect correctly. See below snap-shot, it never detect "H2" which is smaller than "296".

example 2.jpg

[samba_ravi]

=IF(D12="Ribbon Tape Sheet",IF(COUNTIF(C16:H16,"<296"),"WARNING",""))

Please Login or Register  to view this content.

Try this

[shukla.ankur281190]

try this one
C18=IF(D12="Ribbon Tape Sheet",IF(OR(INDEX(C16:H16<320,)),"WARNING",""))

[DTYS]

=IF(D12="Ribbon Tape Sheet",IF(COUNTIF(C16:H16,"<296"),"WARNING",""))

Please Login or Register  to view this content.

Try this

Hi nflsales,

It works, thank you!

[DTYS]

try this one
C18=IF(D12="Ribbon Tape Sheet",IF(OR(INDEX(C16:H16<320,)),"WARNING",""))

Thanks Shukla, nflsales formula works.