Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Programming
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Programming
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. -- Jim Rech Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007-macro programming logic for data validation | Excel Discussion (Misc queries) | |||
Macro / Programming to lock cells | Excel Discussion (Misc queries) | |||
Macro Programming Question | Excel Discussion (Misc queries) | |||
Excel VBA/Macro programming for beginners | New Users to Excel | |||
Programming (macro) breaks due to translation | Excel Discussion (Misc queries) |