IF THEN ELSE formula statement + ISBLANK??

Hello, can I make a formula for 3 blocks of executable statements? (I think this is the right wording.) I know that an IF THEN ELSE statement is 2 blocks. I have that part of the formula functioning properly, but my problem is that I want to add that if any of 3 different cells is blank, leave the cell blank. Here is the IF THEN formula that is functioning:

=IF(OR(K5<=K1,L5<=L1,M5<=M1), "Y", "N")

How do I add another executable statement to also command that if all 3 cells (K5,L5, M5) are blank= blank?

The problem is that the current formula is yielding a "Y" in all my blank rows. Anyone? Thank you in advance!

Try this,
=IF(K5&L5&M5="","",IF(OR(K5<=K1,L5<=L1,M5<=M1), "Y", "N"))

Originally Posted by windknife

Try this,
=IF(K5&L5&M5="","",IF(OR(K5<=K1,L5<=L1,M5<=M1), "Y", "N"))

Thank you for your assistance! This formula results in defaulting the "Y" to be the ELSE. Any value in the reference cell, whether it is greater than or less than the other reference cell (1), results in a "Y".

I don't sure what you want. Could you upload a sample file which describes your expected answer?

Windknife- attachment uploaded. Sorry for being unclear!

I am doing an audit. There are limits to the amount employee can spend for Breakfast vs lunch vs dinner. I want to enter the receipt amount in the appropriate
column and receive and autofill another cell stating if this was or was not within policy limits. (The last half of the formula is working for this). However,
I drag the formula down to all the cells in Column N, they all show "Y".

In the attachment, the yellow highlight is your suggested formula and the orange highlight is AligW's.

Thanks so much!

Try this,

N5
=IF(K5&L5&M5="","",IF(SUMPRODUCT(--(K5:M5<>"")*(K5:M5<$K$1:$M$1))>0, "Y", "N"))

copied down.

Try this,

Q5
=IF(P5="","",IF(O5>P5, "N", "Y"))