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?""")

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?""")

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