| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Joe Shell Wrote: 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 It seems B13 and H13 are not really empty but contain text, probably a formula blank. If you can't avoid text values in these cells, try: =N(B13)*N(H13) -- Aladin Akyurek ------------------------------------------------------------------------ Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165 View this thread: http://www.excelforum.com/showthread...hreadid=319158 |
| 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
