how do i write a formula and keep in in formula form, so it DOESN.
 

i have to take a computer test and one of the questions is to write a formula
i've previously used but write it so the actual formula is shown on the sheet
and when its printed so how do i do i write the formula because everytime i
do it it calculates but i need it to stay in formula form with the = sign too?

Hi!

Precede it with an apostrophie:

'=SUMIF(A1:A100,B1)

Biff

-----Original Message-----
i have to take a computer test and one of the questions
is to write a formula
i've previously used but write it so the actual formula
is shown on the sheet
and when its printed so how do i do i write the formula
because everytime i
do it it calculates but i need it to stay in formula form
with the = sign too?
.

Either pre-format the cell as Text or hit CTRL + `(back quote above TAB key)
to toggle "view formulas" on/off.


Gord Dibben Excel MVP

On Thu, 3 Feb 2005 19:41:01 -0800, norcalchick2207
wrote:

i have to take a computer test and one of the questions is to write a formula
i've previously used but write it so the actual formula is shown on the sheet
and when its printed so how do i do i write the formula because everytime i
do it it calculates but i need it to stay in formula form with the = sign too?