Excel Forum

If a cell has any data, another cell should have a fixed data

Sol Wize

New Member

Members

Forum Posts: 1

Member Since:
November 4, 2019

Offline

November 4, 2019 - 1:53 am

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.

Mynda Treacy

Admin

Forum Posts: 4446

Member Since:
July 16, 2010

Offline

November 4, 2019 - 9:16 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

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online:

Guest(s) 10

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

John Chisholm

vexokeb sdfg

John Jack

Malcolm Toy

Ray-Yu Yang

George Shihadeh

Naomi Rumble

Uwe von Gostomski

Jonathan Jones

drsven

Forum Stats:

Groups: 3

Forums: 24

Topics: 6212

Posts: 27236

Member Stats:

Guest Posters: 49

Members: 31888

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen