| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Hi
try =N(B13)*N(H13) -- Regards Frank Kabel Frankfurt, Germany "Joe Shell" <Joe schrieb im Newsbeitrag ... i am designing a cost spreadsheet for recipes, i need to exclude cells from a formula when, no data is entered, then i need to include the cell when data is entered. Input (b13) Input2 (h13) Result 0 0 #Value! When i enter =sum(b13*h13) i get #Value! If anyone understands my problem, PLEASE HELP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i select different cells to be use in a formula. | Excel Discussion (Misc queries) | |||
| CountIF cells are not empty | Excel Discussion (Misc queries) | |||
| Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
| Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) | |||
| A formula to check differrent cells | Excel Worksheet Functions | |||
Threaded Mode
