try this variation

=IF(B4="","",IF(B4241,1,"value is < 241"))

you may change the last parameter in the 2nd IF statement to any comment you
want

HTH
--
Pls provide your feedback by clicking the Yes button below if this post is
helpful. This will help others to search the archives for result better.


Thank You

cheers, francis



"Workbook" wrote:

I want to modify this formula =IF(Sheet1!N2=241,1,""), so that if N2 is
blank the cell containing this formula will become blank. I have tried
variations of =IF(N2<""(Sheet1!N2<=241,1,""), based on earlier suggestions
but to no avail. Do you have any thoughts?