Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
64
Views
Topic starter
Hi,
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:
=IF(([@BARCODE]>1),"1")
Here barcode is the name of the field.
Posted : 04/11/2019 11:53 am
Hi Sol,
Welcome to our forum!
The fix is easy...remove the double quotes from the 1 in your 'value_if_true' argument. i.e. this:
=IF(([@BARCODE]>1),1)
Not this:
=IF(([@BARCODE]>1),"1")
The double quotes tell Excel to return text, whereas no double quotes around a number will return a number.
Mynda
Posted : 04/11/2019 7:16 pm
