"IF" only I could do this?

  • Thread starter Thread starter Meebers
  • Start date Start date
M

Meebers

Trying to check two cells to see if either is blank or has the text "n/a" in
them and not do the calculation. Using the formula so far
=IF(OR(F60="",(E60=""))," ",MOD(F60-E60,1)). I am working with time
formated cells 00:00 determining time between events. If I add to the
formula i.e. ,(F60="n/a" Excel says there is an error. TIA
 
Maybe you could just check for numbers (including times & dates) in both E60 and
F60:

=if(count(f60:e60)<2,"",mod(f60-e60,1))
 
both work...continuing to test for exceptions...

There will be no exceptions! <g>

Thanks for the feedback!
 
Back
Top