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

The formula you've given us is valid. You haven't told us what's wrong with
the formula, and what results you are looking for.

TIMECALC is not integral to Excel. Is it some addon you are using? If so,
you need to explain what it does.

Regards,
Fred.

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

Hi,

You're going to need to show us the code related to TIMECALC and explain
more about what it is. If H9 and K9 are text then the formula you show us
will not work as written.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Russmaz" wrote:

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