| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If condition for Blank Cell
I wonder if somebody can help me with this matter. I have the following formula
=IF(AND(C22=0,C23=0,C24=0,C25=0,C26=0,C27=0),"", ("( "&C22&" ) "&D22&" ( "&E22&""" ) + ( "&C23&" ) "&D23&" ( "&E23&""" ) + ( "&C24&" ) "&D24&" ( "&E24&""" ) + ( "&C25&" ) "&D25&" ( "&E25&""" ) + ( "&C26&" ) "&D26&" ( "&E26&""" ) + ( "&C27&" ) "&D27&" ( "&E27&""" ) ")) However, it is working only when the cell C22 is empty. I do not know if is possible what I am looking for. Basically, what I need is to active statements that have descriptions typed. For example, I typed numbers in the cell C22, D22, E22 and C23, D23, E23 and I got the following result: ( 2 ) Full ( 23.875" ) + ( 1 ) 2 ( 4.75" ) + ( ) ( " ) + ( ) ( " ) + ( ) ( " ) + ( ) ( " ) Although the cells C24, C25, C26, and C27 do not have any information all the parenthesis () and apostrophes€¯ appear. Could you please tell me how to fix it? Thanks in Advance Maperalia |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If condition for Blank Cell
=IF(C22=0,"","( "&C22&" ) "&D22&" ( "&E22&")")
&IF(C23=0,"","("&C23&" ) "&D23&" ( "&E23&")") &IF(C24=0,"","("&C24&" ) "&D24&" ( "&E24&")") &IF(C25=0,"","("&C25&" ) "&D25&" ( "&E25&")") &IF(C26=0,"","("&C26&" ) "&D26&" ( "&E26&")") &IF(C27=0,"","("&C27&" ) "&D27&" ( "&E27&")") -- __________________________________ HTH Bob "Maperalia" wrote in message ... I wonder if somebody can help me with this matter. I have the following formula =IF(AND(C22=0,C23=0,C24=0,C25=0,C26=0,C27=0),"", ("( "&C22&" ) "&D22&" ( "&E22&""" ) + ( "&C23&" ) "&D23&" ( "&E23&""" ) + ( "&C24&" ) "&D24&" ( "&E24&""" ) + ( "&C25&" ) "&D25&" ( "&E25&""" ) + ( "&C26&" ) "&D26&" ( "&E26&""" ) + ( "&C27&" ) "&D27&" ( "&E27&""" ) ")) However, it is working only when the cell C22 is empty. I do not know if is possible what I am looking for. Basically, what I need is to active statements that have descriptions typed. For example, I typed numbers in the cell C22, D22, E22 and C23, D23, E23 and I got the following result: ( 2 ) Full ( 23.875" ) + ( 1 ) 2 ( 4.75" ) + ( ) ( " ) + ( ) ( " ) + ( ) ( " ) + ( ) ( " ) Although the cells C24, C25, C26, and C27 do not have any information all the parenthesis () and apostrophes" appear. Could you please tell me how to fix it? Thanks in Advance Maperalia |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If condition for Blank Cell
Bob;
Thank you very much IT IS WORKING PERFECTLY!!!! Kind Regards Maperalia "Bob Phillips" wrote: =IF(C22=0,"","( "&C22&" ) "&D22&" ( "&E22&")") &IF(C23=0,"","("&C23&" ) "&D23&" ( "&E23&")") &IF(C24=0,"","("&C24&" ) "&D24&" ( "&E24&")") &IF(C25=0,"","("&C25&" ) "&D25&" ( "&E25&")") &IF(C26=0,"","("&C26&" ) "&D26&" ( "&E26&")") &IF(C27=0,"","("&C27&" ) "&D27&" ( "&E27&")") -- __________________________________ HTH Bob "Maperalia" wrote in message ... I wonder if somebody can help me with this matter. I have the following formula =IF(AND(C22=0,C23=0,C24=0,C25=0,C26=0,C27=0),"", ("( "&C22&" ) "&D22&" ( "&E22&""" ) + ( "&C23&" ) "&D23&" ( "&E23&""" ) + ( "&C24&" ) "&D24&" ( "&E24&""" ) + ( "&C25&" ) "&D25&" ( "&E25&""" ) + ( "&C26&" ) "&D26&" ( "&E26&""" ) + ( "&C27&" ) "&D27&" ( "&E27&""" ) ")) However, it is working only when the cell C22 is empty. I do not know if is possible what I am looking for. Basically, what I need is to active statements that have descriptions typed. For example, I typed numbers in the cell C22, D22, E22 and C23, D23, E23 and I got the following result: ( 2 ) Full ( 23.875" ) + ( 1 ) 2 ( 4.75" ) + ( ) ( " ) + ( ) ( " ) + ( ) ( " ) + ( ) ( " ) Although the cells C24, C25, C26, and C27 do not have any information all the parenthesis () and apostrophes" appear. Could you please tell me how to fix it? Thanks in Advance Maperalia |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If condition for Blank Cell
Hi,
I think you want this: =IF(AND(C22=0,C23=0,C24=0,C25=0,C26=0,C27=0),"", "( "&C22&" ) "&D22&" ( "&E22&" )" & "( "&C23&" ) "&D23&" ( "&E23& " )" & "( "&C24&" ) "&D24&" ( "&E24&" )" & "( "&C25&" ) "&D25&" ( "&E25&" )" & "( "&C26&" ) "&D26&" ( "&E26&" )" & "( "&C27&" ) "&D27&" ( "&E27&" ) ") You can add (+) text you need to concatenate it. and you may or may not need the """ but I took them out. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Maperalia" wrote: I wonder if somebody can help me with this matter. I have the following formula =IF(AND(C22=0,C23=0,C24=0,C25=0,C26=0,C27=0),"", ("( "&C22&" ) "&D22&" ( "&E22&""" ) + ( "&C23&" ) "&D23&" ( "&E23&""" ) + ( "&C24&" ) "&D24&" ( "&E24&""" ) + ( "&C25&" ) "&D25&" ( "&E25&""" ) + ( "&C26&" ) "&D26&" ( "&E26&""" ) + ( "&C27&" ) "&D27&" ( "&E27&""" ) ")) However, it is working only when the cell C22 is empty. I do not know if is possible what I am looking for. Basically, what I need is to active statements that have descriptions typed. For example, I typed numbers in the cell C22, D22, E22 and C23, D23, E23 and I got the following result: ( 2 ) Full ( 23.875" ) + ( 1 ) 2 ( 4.75" ) + ( ) ( " ) + ( ) ( " ) + ( ) ( " ) + ( ) ( " ) Although the cells C24, C25, C26, and C27 do not have any information all the parenthesis () and apostrophes€¯ appear. Could you please tell me how to fix it? Thanks in Advance Maperalia |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If condition for Blank Cell
Shane;
Thanks very much. Works in the way you set it up too. Kind regards "Shane Devenshire" wrote: Hi, I think you want this: =IF(AND(C22=0,C23=0,C24=0,C25=0,C26=0,C27=0),"", "( "&C22&" ) "&D22&" ( "&E22&" )" & "( "&C23&" ) "&D23&" ( "&E23& " )" & "( "&C24&" ) "&D24&" ( "&E24&" )" & "( "&C25&" ) "&D25&" ( "&E25&" )" & "( "&C26&" ) "&D26&" ( "&E26&" )" & "( "&C27&" ) "&D27&" ( "&E27&" ) ") You can add (+) text you need to concatenate it. and you may or may not need the """ but I took them out. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Maperalia" wrote: I wonder if somebody can help me with this matter. I have the following formula =IF(AND(C22=0,C23=0,C24=0,C25=0,C26=0,C27=0),"", ("( "&C22&" ) "&D22&" ( "&E22&""" ) + ( "&C23&" ) "&D23&" ( "&E23&""" ) + ( "&C24&" ) "&D24&" ( "&E24&""" ) + ( "&C25&" ) "&D25&" ( "&E25&""" ) + ( "&C26&" ) "&D26&" ( "&E26&""" ) + ( "&C27&" ) "&D27&" ( "&E27&""" ) ")) However, it is working only when the cell C22 is empty. I do not know if is possible what I am looking for. Basically, what I need is to active statements that have descriptions typed. For example, I typed numbers in the cell C22, D22, E22 and C23, D23, E23 and I got the following result: ( 2 ) Full ( 23.875" ) + ( 1 ) 2 ( 4.75" ) + ( ) ( " ) + ( ) ( " ) + ( ) ( " ) + ( ) ( " ) Although the cells C24, C25, C26, and C27 do not have any information all the parenthesis () and apostrophes€¯ appear. Could you please tell me how to fix it? Thanks in Advance Maperalia |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| blank column condition | Excel Discussion (Misc queries) | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY | Excel Worksheet Functions | |||
| Keep cell blank if condition is false in IF function | Excel Discussion (Misc queries) | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Hybrid Mode
