drop down formulas

[Tim]

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.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )



"Tim" <Tim@discussions.microsoft.com> wrote in message
news:8CFE5A24-B1CE-49E9-8A85-36FDC0FE64B9@microsoft.com...
>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
>
>