View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Russmaz Russmaz is offline
external usenet poster
 
Posts: 2
Default TIMECALC Formulas

I have the formula below

=IF(H9<0.0000001,IF(K9<0.000001,P9-E9,K9-E9),H9-E9)

I want to use the same formula but adapt it to TIMECALC
the formula is used with a funtion in a module on the spread sheet

as the data has been imported as text
cells H9 & K9 may or may not have data in
if not be ignored
If cell have no data in the totals to remain blank

Thanks
Russmaz