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