"IF" only I could do this?
 

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

"IF" only I could do this?
 

Maybe you could just check for numbers (including times & dates) in both E60 and
F60:

=if(count(f60:e60)<2,"",mod(f60-e60,1))



Meebers wrote:

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

--

Dave Peterson

"IF" only I could do this?
 

Try it like this:

=IF(COUNT(E60,F60)=2,MOD(F60-E60,1),"")

--
Biff
Microsoft Excel MVP


"Meebers" wrote in message
...
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

"IF" only I could do this?
 

TX to Dave and Biff....both work...continuing to test for exceptions...

"T. Valko" wrote in message
...
Try it like this:

=IF(COUNT(E60,F60)=2,MOD(F60-E60,1),"")

--
Biff
Microsoft Excel MVP


"Meebers" wrote in message
...
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

"IF" only I could do this?
 

both work...continuing to test for exceptions...

There will be no exceptions! <g

Thanks for the feedback!


--
Biff
Microsoft Excel MVP


"Meebers" wrote in message
...
TX to Dave and Biff....both work...continuing to test for exceptions...

"T. Valko" wrote in message
...
Try it like this:

=IF(COUNT(E60,F60)=2,MOD(F60-E60,1),"")

--
Biff
Microsoft Excel MVP


"Meebers" wrote in message
...
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