Making a Cell Go Blank

[Workbook]

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?

 

[muddan madhu]

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

 

[DILipandey]

Hi,
Try following:-
=IF(OR(N2<>"",N2>=241),1,"").
thanks
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India

 

[xlmate]

try this variation

=IF(B4="","",IF(B4>241,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]

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

 

[Workbook]

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

 

[Workbook]

o cool thank you for your input; looks great!

try this variation

=IF(B4="","",IF(B4>241,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