drop down formulas

[Guest]

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

 

[Arvi Laanemets]

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.