formula help

W

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
 
P

Peo Sjoblom

Try

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

--
Regards,

Peo Sjoblom

(No private emails please)
 
P

Peo Sjoblom

Oops! put quotes around Joe


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

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top