Why is "VALUE" appearing?

wkirkcrawford

New Member
Joined
Dec 7, 2013
Messages
48
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
 

Some videos you may like

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
Joined
Mar 17, 2004
Messages
19,955
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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
Joined
Dec 7, 2013
Messages
48
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,985
Messages
5,526,063
Members
409,685
Latest member
Davetom

This Week's Hot Topics

Top