Making a Cell Go Blank
 

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?

Making a Cell Go Blank
 

=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?

Making a Cell Go Blank
 

Hi,
Try following:-
=IF(OR(N2<"",N2=241),1,"").
thanks
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"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?

Making a Cell Go Blank
 

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?

Making a Cell Go Blank
 

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?

Making a Cell Go Blank
 

I am grateful for your help. Thank you very much. This is great.

"DILipandey" wrote:

Hi,
Try following:-
=IF(OR(N2<"",N2=241),1,"").
thanks
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"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?

Making a Cell Go Blank
 

o cool thank you for your input; looks great!

"xlmate" wrote:

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?