Text question comes up even if cell is blank

P

pano

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

Mike

Your formula is evaluating zero as a number, try this.

=IF(G43>0,"You have banked today how much did you bank?","")
 
P

pano

Your formula is evaluating zero as a number, try this.

=IF(G43>0,"You have banked today how much did you bank?","")






- Show quoted text -

Thankyou your formula works perfectly.

Regrds Stephen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top