Calc2

[TCEBob]

There is a delightful little program called Calc2, http://www.calc2.net/ , which
combines a desktop calculator with a spreadsheet. The spreadsheet portion can
act like a paper tape or can be programmed like a spreadsheet, with many of the
standard functions. No, I don't work for them. But I like it for small chores.
One big advantage is that the formula can be open to view together with the
result.

Which gets to the point in Excel: can I format a cell to show the formula and
another, adjacent, cell to show the results?

rs

 

[Frank Kabel]

Hi
you could enter the formula in one cell and use the following user
defined function to show the formula txt:
public function get_formula(nrg as range)
if rng.hasformula then
get_formula=rng.formula
else
get_formula=""
end f
end function

and use it lit
=GET_FORMULA(A1)

--
Regards
Frank Kabel
Frankfurt, Germany

There is a delightful little program called Calc2,

http://www.calc2.net/ , which

 

[RagDyer]

Just copy the formula to both cells, then simply remove the equal sign from
one of them.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

There is a delightful little program called Calc2, http://www.calc2.net/ ,
which
combines a desktop calculator with a spreadsheet. The spreadsheet portion
can
act like a paper tape or can be programmed like a spreadsheet, with many of
the
standard functions. No, I don't work for them. But I like it for small
chores.
One big advantage is that the formula can be open to view together with the
result.

Which gets to the point in Excel: can I format a cell to show the formula
and
another, adjacent, cell to show the results?

rs

 

[TCEBob]

I hate when I answer a query and get no feedback! Frank and RagDyer, thank you
very much. I think I'll go with the simpler suggestion.

rs