software

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(and(F4gt;0,F8gt;0),(F4/F8),quot;quot;)

try this...I think it would do what you want.

quot;belliotbquot; gt; wrote in message
...
gt;i have 2 cells: f4 and f8 on status spreadsheet. they may not be populated,
gt; (have a value in the cell), all the time. need a formula that will
gt; calculate
gt; when only both of them are populated. and not return a #div/0!, divide by
gt; zero error. when neither or only one of those cells are populated
belliotb wrote:
gt; i have 2 cells: f4 and f8 on status spreadsheet. they may
gt; not be populated, (have a value in the cell), all the time.
gt; need a formula that will calculate when only both of them
gt; are populated. and not return a #div/0!, divide by zero error,
gt; when neither or only one of those cells are populated

=if(or(f4=quot;quot;, f8=quot;quot;, f8=0), quot;quot;, f4/f8)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! ! !

quot; wrote:

gt; belliotb wrote:
gt; gt; i have 2 cells: f4 and f8 on status spreadsheet. they may
gt; gt; not be populated, (have a value in the cell), all the time.
gt; gt; need a formula that will calculate when only both of them
gt; gt; are populated. and not return a #div/0!, divide by zero error,
gt; gt; when neither or only one of those cells are populated
gt;
gt; =if(or(f4=quot;quot;, f8=quot;quot;, f8=0), quot;quot;, f4/f8)
gt;
gt;