View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Té is offline
external usenet poster
 
Posts: 75
Default Function within a cell that has a number

I want the result to go below the number or next to it some how

"Need Help on axis problem in a chart" wrote:

if you leave the 500 in the same cell, how are u going to show your result of
the function? explain

"Té" wrote:

I have a number in a1 which is 500. Is there a way I can leave the 500 in
place, along with add a formula to that cell as well. I want to add a1+b1,
but I want to keep the 500 there. I know alt + enter goes down to the next
line, but when I insert the formula it doesnt work.