Protect formula
 

I have a excel spread sheet that I have Protect all formula but in this one
roll I have this formula =SUM(G45) but what I need to do is let others add to
the formula like =SUM(G45)+2000+3000 so I need to Protect this =SUM(G45) and
let them add to it


Hope some one can help

Protect formula
 

Wouldn't it be better to create an input range, say in G46:G50, or even
G145:G150, where users can enter these additional values? Change your
formula to =SUM(G45:G50), or =G45+SUM(G145:G150)

"joen" wrote:

I have a excel spread sheet that I have Protect all formula but in this one
roll I have this formula =SUM(G45) but what I need to do is let others add to
the formula like =SUM(G45)+2000+3000 so I need to Protect this =SUM(G45) and
let them add to it


Hope some one can help