View Single Post
  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

And if you want a comment in a cell that returns text:

=a1&" "&text(b1,"$0.00") & text("this is a comment",";;;")



danno1 wrote:

I'd like to put a few notes in my excel formulas to refer to later when I
forgot where I may have gotten a number I used. Something like <=c3*b4*20"the
number of work days in May"
Is this possible? Basically I'd like to add text in formulas that is ignored
by excel


--

Dave Peterson