formula help

[Guest]

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

 

[Peo Sjoblom]

Try

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

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Peo Sjoblom]

Oops! put quotes around Joe


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

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Guest]

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