formula help

[WYN]

hi excelers, i need a formula to do the following ( if possible) in cell e1 i
enter a name of a staff member,then add two other cells and multiply by
dollar number. i have tried a few different ways but can't seem to get it
right.this what i have tried =if(e1=joe,d5:d6*$10.00).any help will save the
few hairs i have left on my head. thx
--
wynb

[Peo Sjoblom]

Try

=if(e1=joe,(d5+d6)*10.00)

--
Regards,

Peo Sjoblom

(No private emails please)


"WYN" <WYN@discussions.microsoft.com> wrote in message
news:3A2BAFDE-BC32-4574-A116-EEFD4ED408C3@microsoft.com...
> hi excelers, i need a formula to do the following ( if possible) in cell
> e1 i
> enter a name of a staff member,then add two other cells and multiply by
> dollar number. i have tried a few different ways but can't seem to get it
> right.this what i have tried =if(e1=joe,d5:d6*$10.00).any help will save
> the
> few hairs i have left on my head. thx
> --
> wynb

[Peo Sjoblom]

Oops! put quotes around Joe


=if(e1="joe",(d5+d6)*10.00)

--
Regards,

Peo Sjoblom

(No private emails please)


"Peo Sjoblom" <terre08@mvps.org> wrote in message
news:OV$RZ6WbFHA.3492@TK2MSFTNGP14.phx.gbl...
> Try
>
> =if(e1=joe,(d5+d6)*10.00)
>
> --
> Regards,
>
> Peo Sjoblom
>
> (No private emails please)
>
>
> "WYN" <WYN@discussions.microsoft.com> wrote in message
> news:3A2BAFDE-BC32-4574-A116-EEFD4ED408C3@microsoft.com...
>> hi excelers, i need a formula to do the following ( if possible) in cell
>> e1 i
>> enter a name of a staff member,then add two other cells and multiply by
>> dollar number. i have tried a few different ways but can't seem to get it
>> right.this what i have tried =if(e1=joe,d5:d6*$10.00).any help will save
>> the
>> few hairs i have left on my head. thx
>> --
>> wynb
>

[WYN]

thank you peo that works great.(i was down to my last hair)
thx again.
--
wynb


"WYN" wrote:

> hi excelers, i need a formula to do the following ( if possible) in cell e1 i
> enter a name of a staff member,then add two other cells and multiply by
> dollar number. i have tried a few different ways but can't seem to get it
> right.this what i have tried =if(e1=joe,d5:d6*$10.00).any help will save the
> few hairs i have left on my head. thx
> --
> wynb