27th February 2006, 08:43 AM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 578
|
|
Quote:
|
Originally Posted by dingoboy
I have a divisor in column c, eg 64. i need this to remain the same if the bet looses, BUT, i need it to drop by "div paid-1" which is coulmn f.
I have gone through the help files but cant find referance to it,
And if some one can tell me how to "lock" some of the columns,..not all of them so the info cant be changed ? IM LOST ! Thanks for any help.
|
You need a formula along the lines of:
=IF(B50="W",C50-(A50-1),C50)
where b50 is the result (W for a Win L for a loss); c50 is the divisor; a50 is the dividend.
To lock some columns/cells highlight what you want locked then goto the drop-down menu: Format/Cells/Protection & tick Lock.
then when you have finished doing all your worksheet then goto the drop-down menu: Tools/Protection/ProtectSheet & issue a password in line provided.
Best of luck. |