Function HELP!!!
 

I need to correct this function to calculate the difference between two cells
which can end up as negative number. Bellow is a sample of the function:

What I have is this: =IF(I7<0.5,K$2-I7,0). Here cell K$2 = 12:00 P.M. and
cell I7 = 12:25 P.M. I need to be able to show both negative and or positive
numbers as the need arrises. If there are no value in either cell's, then,
show "" an empty string instead. Is this possible?

==IF(OR(K$2="",I7=""),"",IF(I7<0.5,MOD(K$2-I7,1),0))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jay" wrote in message
...
I need to correct this function to calculate the difference between two
cells
which can end up as negative number. Bellow is a sample of the function:

What I have is this: =IF(I7<0.5,K$2-I7,0). Here cell K$2 = 12:00 P.M. and
cell I7 = 12:25 P.M. I need to be able to show both negative and or
positive
numbers as the need arrises. If there are no value in either cell's, then,
show "" an empty string instead. Is this possible?

Thanks Bob, appreciate the input!

"Bob Phillips" wrote:

==IF(OR(K$2="",I7=""),"",IF(I7<0.5,MOD(K$2-I7,1),0))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jay" wrote in message
...
I need to correct this function to calculate the difference between two
cells
which can end up as negative number. Bellow is a sample of the function:

What I have is this: =IF(I7<0.5,K$2-I7,0). Here cell K$2 = 12:00 P.M. and
cell I7 = 12:25 P.M. I need to be able to show both negative and or
positive
numbers as the need arrises. If there are no value in either cell's, then,
show "" an empty string instead. Is this possible?