formula help
 

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

Try

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

--
Regards,

Peo Sjoblom

(No private emails please)


"WYN" wrote in message
...
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

Oops! put quotes around Joe


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

--
Regards,

Peo Sjoblom

(No private emails please)


"Peo Sjoblom" wrote in message
...
Try

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

--
Regards,

Peo Sjoblom

(No private emails please)


"WYN" wrote in message
...
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

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