View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard Schollar[_2_] Richard Schollar[_2_] is offline
external usenet poster
 
Posts: 29
Default Sum() formula with Text

Hi Mike

Use N():

=100+200+N("The second number came from xyz")



"Mike H." wrote in message
...
Is there a way to have a formula contain something like this:

=100+200+value("The second number came from xyz")
and have the formula just equal the 300. Value() doesn't work. Does
something? I do not want to use a comment.