Why is "VALUE" appearing?

[wkirkcrawford]

Thisis the code that I was using. Note:ISBLANK. IF(ISBLANK(R121"",IF(U121=0,"",MOD(R121-I121,1)))

I changed it toIF(R121<>"",IF(U121=0,"",MOD(R121-I121,1)))

And now I get"FALSE" in cells that are not used yet.

Please note, ifthere is no 'Reading', then the row is blank. But if there is a'Reading' and the number of units is "0", then the 'Time between thelast shot' should be blank.

If you need to see the file, I have a shorten version.

W. Kirk Crawford
Tularosa, New Mexico

 

[Scott Huish]

You get FALSE because you haven't filled in the FALSE part of the formula yet from the original IF.

Does this do what you need?

=IF(COUNT(R121,I121)=2,IF(U121,MOD(R121-I121,1),""),"")

 

[wkirkcrawford]

Scott,

Thank you very much. I though I was overlooking something, but it worked in another area.

Thank you again.

W. Kirk Crawford
Tularosa, New Mexico