Merge two formulas

Perhaps

Formula:

Please Login or Register  to view this content.

Thank you for your answer.
Formula not working properly,
please check example: drive.google.com/drive/folders/1xJC1K2v7z1KZIbI6wBpDT-EUl4nJDdMW

Thanks.

Try this

=IF(OR(AND(ISNUMBER(I12),I12>G12,I12<H12),AND(ISNUMBER(J12),J12>G12,J12<H12)),"P",IF(OR(ISNUMBER(I12),ISNUMBER(J12)),"F",""))

Thank you, but its not working.

Define "not working".

There are instructions at the top of the page explaining how to attach your sample workbook.

Administrative Note:

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you