Function HELP!!!

J

Jay

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?
 
B

Bob Phillips

==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)
 
J

Jay

Thanks Bob, appreciate the input!

Bob Phillips said:
==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)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple IF conditions 3
Calculating the number of minutes between days 5
Count Dates in a range based on Column Header Id without using sum-product 1
Hours between to two times 3
Sumproduct Help! 3
INDEX function array causes problem when attempting to use LARGEfunction to sort positive and negati 10
Need some help with a COUNTIF function 4
VLookup IF word in string exists within cell, use the word. 0

Top