Making a Cell Go Blank

  • Thread starter Thread starter Workbook
  • Start date Start date
W

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?
 
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
 
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
 
o cool thank you for your input; looks great!

xlmate said:
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
Click to expand...
 
Back
Top