| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a Blank Cell | Charts and Charting in Excel | |||
| Making a cell show blank until data is entered | Excel Discussion (Misc queries) | |||
| Making a cell blank or empty without deleting it | New Users to Excel | |||
| MAKING THE FOLLOWING EQUATION DISPLAY A BLANK CELL IF NO DATA INPU | Excel Discussion (Misc queries) | |||
| Making Cell Blank | Excel Worksheet Functions | |||
Linear Mode
