Calc2

  • Thread starter Thread starter TCEBob
  • Start date Start date
T

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
 
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

TCEBob said:
There is a delightful little program called Calc2,
Click to expand...
http://www.calc2.net/ , which
 
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
 
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
 
Back
Top