# How do I use either entered data (cell 1) or established data (cell 2) in 3rd cell ?

1. ## How do I use either entered data (cell 1) or established data (cell 2) in 3rd cell ?

I download Inventory Data from a company data base. I'll then inventory the racks of stock. Rather than looking through my sheets for the SKU item, I'd like to simply record the SKU's as I go (and any change in Quantity if needed) from the shelves into my Tablet. I know what quantities I should have per Company Data Base. I have a routine to show a Under-Even-Over of My Count vs Data Base. How do I get Excel to use either my Shelf Quantity Entered -or if no entry is made for quantity- use the Data Base Quantity in 'Column I' so 'Column J' shows my +/-/= status ?

What I seem to know: Cells with formulas and a retrieved '0' value keep my various ideas from working.
Have tried Helper Columns.
Columns can be re-arranged to facilitate a working sheet if needed.

Help !! How should I structure a Formula to calculate 'Column J' correctly ???? (Sample Workbook Attached)

2. ## Re: How do I use either entered data (cell 1) or established data (cell 2) in 3rd cell ?

So if a value appears in Col B, then use it, otherwise use the value in G? And if it's 0, you want to use the value in G?
=IF(B2=0, G2, IF(B2="", G2,B2))

3. ## Re: How do I use either entered data (cell 1) or established data (cell 2) in 3rd cell ?

Originally Posted by chemistb
=if(b2=0, g2, if(b2="", g2,b2))
????
=if(b2<>0, b2, g2))

4. ## Re: How do I use either entered data (cell 1) or established data (cell 2) in 3rd cell ?

Long day

There are currently 1 users browsing this thread. (0 members and 1 guests)