| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| change function variable prompts?? | Excel Worksheet Functions | |||
Threaded Mode
