| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text question comes up even if cell is blank
Hello all,
I have in G43 the following formula which counts all variations of the word bank, Bank,Banking,Banked,banked well it seems to work. it does count them. =COUNTIF(G$5:G$40,"*bank*") I have this in another cell g42 which I hoped would tell me if the cell is blank dont say anything but if the cell has any number in it say you have banked today how much did you bank. This is the formula I am having trouble with any ideas. It does'nt matter if g43 has a number or not it still shows up =IF(ISNUMBER(G$43),"You have banked today how much did you bank?""") |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text question comes up even if cell is blank
Your formula is evaluating zero as a number, try this.
=IF(G430,"You have banked today how much did you bank?","") "pano" wrote: Hello all, I have in G43 the following formula which counts all variations of the word bank, Bank,Banking,Banked,banked well it seems to work. it does count them. =COUNTIF(G$5:G$40,"*bank*") I have this in another cell g42 which I hoped would tell me if the cell is blank dont say anything but if the cell has any number in it say you have banked today how much did you bank. This is the formula I am having trouble with any ideas. It does'nt matter if g43 has a number or not it still shows up =IF(ISNUMBER(G$43),"You have banked today how much did you bank?""") |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text question comes up even if cell is blank
On Feb 16, 11:09 pm, Mike wrote:
Your formula is evaluating zero as a number, try this. =IF(G430,"You have banked today how much did you bank?","") "pano" wrote: Hello all, I have in G43 the following formula which counts all variations of the word bank, Bank,Banking,Banked,banked well it seems to work. it does count them. =COUNTIF(G$5:G$40,"*bank*") I have this in another cell g42 which I hoped would tell me if the cell is blank dont say anything but if the cell has any number in it say you have banked today how much did you bank. This is the formula I am having trouble with any ideas. It does'nt matter if g43 has a number or not it still shows up =IF(ISNUMBER(G$43),"You have banked today how much did you bank?""")- Hide quoted text - - Show quoted text - Thankyou your formula works perfectly. Regrds Stephen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell text not displaying into next blank cell | Excel Discussion (Misc queries) | |||
| Multiple formatting in text cell blank it out! | Excel Discussion (Misc queries) | |||
| Can I formulaically set a cell to blank (non-Text, no value)? | Excel Worksheet Functions | |||
| allow text over a non-blank cell in Excel | Excel Discussion (Misc queries) | |||
| Blank cell conversion to text | New Users to Excel | |||
Linear Mode
