Thread: if worksheet function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
supersonikk supersonikk is offline
external usenet poster
  
Posts: 6
Default if worksheet function
Hi all,

Is there a way to write a formula so that if a cell does not contain any
numbers, just text, it result as 0 number?

i.e.:

=if(C5<number,0,C5)

--
Thanks,
Marko
Reply With QuoteReply With Quote