Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop down formulas
I have a drop down box on sheet 2 (linda, richard, tim, brian, susan)
I am using the drop down box on b8 sheet 1 to select the name used. Each name is also on lines b23-b27 I want g23-27 to use a formula like this....for each line...assuming b23 is brian then g23's formula would be.... Logical_test: G8-'Brian' Value_if_true: (G17*0.05)+g8*0.05 Value_if_false: g8*0.05 So if g8 =700 and g17 = 532 and Brian is the name selected from the drop down box then g23=61.60 else if g8=700 and g17= 532 and Susan is the name selected from the drop down box then g23 = 35.00 any help would be welcome |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop down formulas
Hi
G23=($G8+$G17*($B23=$B$8))*0.05 or G23=($G$8+$G$17*($B23=$B$8))*0.05 (it depends on, are G8 and G17 locked values, or change when the formula is copied) Btw. Your explanation is really messy, I did my best to get the meaning of it, but I'm not sure at all, I did get it right. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Tim" wrote in message ... I have a drop down box on sheet 2 (linda, richard, tim, brian, susan) I am using the drop down box on b8 sheet 1 to select the name used. Each name is also on lines b23-b27 I want g23-27 to use a formula like this....for each line...assuming b23 is brian then g23's formula would be.... Logical_test: G8-'Brian' Value_if_true: (G17*0.05)+g8*0.05 Value_if_false: g8*0.05 So if g8 =700 and g17 = 532 and Brian is the name selected from the drop down box then g23=61.60 else if g8=700 and g17= 532 and Susan is the name selected from the drop down box then g23 = 35.00 any help would be welcome |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clearing the Values in a Drop - Down List | Excel Discussion (Misc queries) | |||
Limit drop down list and linking to other info | Excel Worksheet Functions | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
using formulas in a drop down box | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |