| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Threaded Mode
