Easy Newbie Question

[jgeldardphillips]

Hi all, trying to help daughter with this basic excel formula to apply to all of column M

=IF(K1>=L1,"Y","N")

but I don't want to return a value where L1 is blank.

I apologise for such a basic question, but have been searching & trying code from online without success and my daughter is sighing a lot now!

Many thanks in advance

 

[jproffer]

=IF(L1="","",IF(K1>=L1,"Y","N"))

try that

 

[jgeldardphillips]

Perfect - thank you so much for your prompt response. We're very grateful!

 

[jproffer]

No problem at all. Glad to help (even with...homework? LOL) . Thanks for the feedback