View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Distinguish Letters vs. Numbers in an IF Statement

On Fri, 31 Jul 2009 14:34:04 -0400, "William Wolfe"
wrote:

I need to write an IF statement so that if the contents of a cell are a
letter do one thing, it they are a number do another.

How do I distinguish between the two in an IF statement?

Thanks,

W. Wolfe


=if(isnumber(cell_ref),"do this","do that")
--ron