November 4, 2019
I'm trying to fill a cell value based on whether another cell has any value whatsoever. So if value of Cell A2 is ABC, Cell E2 should have value 1.
I use the value in E2 to sum up the total.
Now the problem I face is that although I'm getting the Value 1 in E2 using IF function. The data is not considered numeric & the sum is always zero.
But if I manually enter 1 in each cell, it is ok. Kindly help.
I'm using the below formula:
Here barcode is the name of the field.
July 16, 2010
Welcome to our forum!
The fix is easy...remove the double quotes from the 1 in your 'value_if_true' argument. i.e. this:
The double quotes tell Excel to return text, whereas no double quotes around a number will return a number.