|
Displaying a blank cell
I have this formula in my spreadsheet...
=IF('Prospect Questions'!B61=""," ","") Obviously, if cell B61 on the Prospect Questions work sheet is blank, I want this new cell to appear with a blank. Otherwise I want the contents of what's in B61. When I enter this formula, it is displaying the formula. What am I doing wrong??? Is the formatting wrong??? Or just the formula?? HELP! |
Have you text format in the cell with the formula? Also,
=IF('Prospect Questions'!B61="","",'Prospect Questions'!B61) I noticed that you used a space in your formula " " as opposed to "", typo? Regards, Peo Sjoblom "RTP" wrote: I have this formula in my spreadsheet... =IF('Prospect Questions'!B61=""," ","") Obviously, if cell B61 on the Prospect Questions work sheet is blank, I want this new cell to appear with a blank. Otherwise I want the contents of what's in B61. When I enter this formula, it is displaying the formula. What am I doing wrong??? Is the formatting wrong??? Or just the formula?? HELP! |
I now have ""...no space....however that did not fix it.
=IF('Prospect Questions'!B61="","",'Prospect Questions'!B61) Does the format of cell 'Prospect Questions'!B61 have to be text as well as the cell in which I have the formula above??? "Peo Sjoblom" wrote: Have you text format in the cell with the formula? Also, =IF('Prospect Questions'!B61="","",'Prospect Questions'!B61) I noticed that you used a space in your formula " " as opposed to "", typo? Regards, Peo Sjoblom "RTP" wrote: I have this formula in my spreadsheet... =IF('Prospect Questions'!B61=""," ","") Obviously, if cell B61 on the Prospect Questions work sheet is blank, I want this new cell to appear with a blank. Otherwise I want the contents of what's in B61. When I enter this formula, it is displaying the formula. What am I doing wrong??? Is the formatting wrong??? Or just the formula?? HELP! |
This is the formula you posted
=IF('Prospect Questions'!B61=""," ","") that looks liek a space to me. Regardless, format the the cell with the formula as general or number, then whil still selected do editreplace, replace = with =, that sometimes help to get excel to calculate the formula as opposed to just displaying it Regards, Peo Sjoblom "RTP" wrote: I now have ""...no space....however that did not fix it. =IF('Prospect Questions'!B61="","",'Prospect Questions'!B61) Does the format of cell 'Prospect Questions'!B61 have to be text as well as the cell in which I have the formula above??? "Peo Sjoblom" wrote: Have you text format in the cell with the formula? Also, =IF('Prospect Questions'!B61="","",'Prospect Questions'!B61) I noticed that you used a space in your formula " " as opposed to "", typo? Regards, Peo Sjoblom "RTP" wrote: I have this formula in my spreadsheet... =IF('Prospect Questions'!B61=""," ","") Obviously, if cell B61 on the Prospect Questions work sheet is blank, I want this new cell to appear with a blank. Otherwise I want the contents of what's in B61. When I enter this formula, it is displaying the formula. What am I doing wrong??? Is the formatting wrong??? Or just the formula?? HELP! |
RTP,
If you want your formula to return the contents of cell 'Prospect Questions'!B61, shouldn't it say so, instead of asking it to return " ", or ""? I would use: =IF('Prospect Questions'!B610,'Prospect Questions'!B61,"") In English: if the contents of 'Prospect Questions'!B61 are more than zero (and text is that, in Excel), return those contents, if not, return blank. It worked for me. Your formula returned nothing in my spreadsheet, with or without the space. Best wishes. IanRoy "Peo Sjoblom" wrote: This is the formula you posted =IF('Prospect Questions'!B61=""," ","") that looks liek a space to me. Regardless, format the the cell with the formula as general or number, then whil still selected do editreplace, replace = with =, that sometimes help to get excel to calculate the formula as opposed to just displaying it Regards, Peo Sjoblom "RTP" wrote: I now have ""...no space....however that did not fix it. =IF('Prospect Questions'!B61="","",'Prospect Questions'!B61) Does the format of cell 'Prospect Questions'!B61 have to be text as well as the cell in which I have the formula above??? "Peo Sjoblom" wrote: Have you text format in the cell with the formula? Also, =IF('Prospect Questions'!B61="","",'Prospect Questions'!B61) I noticed that you used a space in your formula " " as opposed to "", typo? Regards, Peo Sjoblom "RTP" wrote: I have this formula in my spreadsheet... =IF('Prospect Questions'!B61=""," ","") Obviously, if cell B61 on the Prospect Questions work sheet is blank, I want this new cell to appear with a blank. Otherwise I want the contents of what's in B61. When I enter this formula, it is displaying the formula. What am I doing wrong??? Is the formatting wrong??? Or just the formula?? HELP! |
| All times are GMT +1. The time now is 09:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com