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
<[email protected]> 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?