Macro Programming

  • Thread starter Thread starter Jamie
  • Start date Start date
J

Jamie

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!
 
Wouldn't it be better to put a formula in Bid Ext that is flexible enough to
return the right result depending on Unit? Like:

=IF(Unit="LS",Quantity*Unit Price,IF(Unit="LP",Quantity*Unit Price *
1.5,""))

This could actually be simplified but it is just an example.
 
Back
Top