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