Terrific! This works awesome. Much thanks for your help.

"muddan madhu" wrote:

=IF(AND(Sheet1!N2<"",Sheet1!N2=240),1,0)

On Feb 4, 12:54 pm, 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?