iserror
Maybe this:
=IF(COUNT(E4:F4)=2,F4/E4,"")
--
Biff
Microsoft Excel MVP
"dnmusic" wrote in message
...
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?
|