Avoid 0 & #DIV/0!

April 5, 2009 at 20:55:32
Specs: Windows XP
Hope someone can help..hope to have a blank cell return to avoid #DIV/0! or a zero after excuted this formula - =100*((MAX((MAX(C542:E542)-F542),(F542-MIN(C542:E542))))/F542)

See More: Avoid 0 & #DIV/0!

Report •


#1
April 6, 2009 at 03:47:02
shove the following around your formula:

=IF(SUM(F542)=0,"", your formula here)


Report •

#2
April 6, 2009 at 23:43:06
Thank you jon k

Report •

#3
April 7, 2009 at 00:06:54
Hi Jon,

When I export a set of data to Excel, the date/time format is not recognized. kindly pls advise...Thank you


Report •

Related Solutions

#4
April 7, 2009 at 05:07:00
...you should probably start a new thread for this. And I need a bit more detail than you have provided. What format is it coming in? Is it a raw integer like

20090301235959

(which would map to 01/03/2009 23:59:59)

or something else? Also, how are you importing the data?


Report •

#5
April 7, 2009 at 08:50:10
Exported date and time are are downloaded from a electrical device (Fluke meter)

Exported format - 01/03/2009 23:59:59, but excel does not recognise this format at all...can't even use "format cell" to chage it...


Report •

#6
April 7, 2009 at 09:46:24
re: you should probably start a new thread for this.

I agree. I think I have an answer, but I'd prefer to answer in a relevant thread.

If the subject line matches the contents of the thread, searching for the same information later on is more effcient for the searcher.


Report •

#7
April 7, 2009 at 23:12:12
Could u able to elaborate on it further, doesn't understand...

Thank you


Report •


Ask Question