# Why is "VALUE" appearing?

#### wkirkcrawford

##### New Member
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.

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

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### Scott Huish

##### MrExcel MVP
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

##### New Member
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

Replies
3
Views
174
Replies
4
Views
168
Replies
2
Views
20K
Replies
7
Views
4K
Replies
22
Views
4K