suppose I have cell d4 blank and i want a if formula in e4 that states that:
=if(d4,"completed","not completed")
scenario: if i put a number in d4 the cell e4 will automatically become completed
if cell d4 is blank the default value of e4 will not completed
my problem is: If I put a word not a numeric in cell d4 the cell e4 will become #value instead completed. Can you help me what is the best formula so that I can put either a word or number in cell d4 to become completed. thank you.
Is anyone to help me?
=if(d4,"completed","not completed")
scenario: if i put a number in d4 the cell e4 will automatically become completed
if cell d4 is blank the default value of e4 will not completed
my problem is: If I put a word not a numeric in cell d4 the cell e4 will become #value instead completed. Can you help me what is the best formula so that I can put either a word or number in cell d4 to become completed. thank you.
Is anyone to help me?
Last edited: