Protect formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Back
Top