| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
divide by zero
i have 2 cells: f4 and f8 on status spreadsheet. they may not be populated,
(have a value in the cell), all the time. need a formula that will calculate when only both of them are populated. and not return a #div/0!, divide by zero error. when neither or only one of those cells are populated |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
divide by zero
=If(and(F40,F80),(F4/F8),"")
try this...I think it would do what you want. "belliotb" wrote in message ... i have 2 cells: f4 and f8 on status spreadsheet. they may not be populated, (have a value in the cell), all the time. need a formula that will calculate when only both of them are populated. and not return a #div/0!, divide by zero error. when neither or only one of those cells are populated |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
divide by zero
belliotb wrote:
i have 2 cells: f4 and f8 on status spreadsheet. they may not be populated, (have a value in the cell), all the time. need a formula that will calculate when only both of them are populated. and not return a #div/0!, divide by zero error, when neither or only one of those cells are populated =if(or(f4="", f8="", f8=0), "", f4/f8) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
divide by zero
To everyone - Thank you very much. Was running out of time to have my status
sheet ready for todays afternoon meeting. Was being pulled in to many directions to get my thought processes coordinated. Thanks again! ! ! " wrote: belliotb wrote: i have 2 cells: f4 and f8 on status spreadsheet. they may not be populated, (have a value in the cell), all the time. need a formula that will calculate when only both of them are populated. and not return a #div/0!, divide by zero error, when neither or only one of those cells are populated =if(or(f4="", f8="", f8=0), "", f4/f8) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you divide two cells in a pivot table to equal a %? | Excel Worksheet Functions | |||
| how do I Divide "/" a row of cells by another row of cells? | Excel Worksheet Functions | |||
| how do i subtract and divide | Excel Worksheet Functions | |||
| subtract and divide | Excel Worksheet Functions | |||
| Divide one row over other row I dont wont to divide one number | Excel Discussion (Misc queries) | |||
Linear Mode
