Help with IF and OR functions

C

Chris Dunigan

I need a formula that will show "Y" if a cell value is numeric. There
is the possibility that the cell could contain text or be blank.
Have tried using the following formula, but it doesn't seem to work:
=IF(OR((ISERROR(G6)=FALSE),(ISNUMBER(G6))),"Y","N").

Can anyone help me?

Thanks,
Chris
 

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

Similar Threads

Newbie Help - IF Yes No Function 0
Compute Additional Hours Needed Using "if" or "lookup" 1
Is a Nested Formula what I need? 1
IF Statements 1
Filter with an IF, AND, NOT formula 1
Word 2007 flash screen upside down and Word2007 cannot be used 0
Cumulative formula for word table 0
If, Or, and 5

Top