View Single Post
  #2   Report Post  
Biff
 
Posts: n/a
Default

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