i work with spreadsheets that i need certain formula's in
different cells in the same row based on 1 cell's data in
that row. then i need to lock those changed cells so they
cant be edited when the worksheet is protected. for
instance:

Quantity | Unit | Unit Price | Bid Ext |
----------------------------------------
LS $500.00
LS $1,500.00

so if unit = LS then quantity = 1, bid ext = ROUND
((quantity*unit price),2) and then have quantity, unit,
bid ext to be locked when the worksheet is protected. I
will have these LS units scattered thru ~150 rows in the
spreadsheet as well...

any help or direction would be appreciated. thanks!