Maybe you can check for numbers:
=if(count(e4:f4)<2,"",if(e4=0,0,f4/e4))

And I only checked for a non-zero denominator.



dnmusic wrote:

ok, i have a formula that works but i want to have the cell blank when
nothing is in the other cells... =IF(ISERROR(F4/E4,0,F4/E4) which gives me
0.00 in cell G4. question is, what do i need to add to the formula to have
G4 blank until valves are added to cells F4 and E4... i.e. ,"", but i can't
get it right... any help?

--

Dave Peterson