Getting Excel to ignore Blank cells in a formula

**SLOWBRAH** · 04-16-2014, 09:43 AM

Equipment Pickup Check List (Help Version).xlsx

In the attached file I have randomly "Inventoried" the listed items on tab 6. The quantity "found" is listed in Column V on tab 6 (Again, random numbers). I left three blank (In RED). When left blank they are counted short. How do I avoid this? The "Shortage list" is on the "Shortage" tab. I also want the "#VALUE!" to go away when trying to calculate "Items Short" in the Shortage tab. As you may notice, my tab 6 opens about half way... how do I get it to open at the top left?

1.) Have excel NOT count blank cells as "short inventory"
2.) Have excel ignore cells with no data when calculating my items short (Shortage tab)
3.) Have tab 6 open at the top left.

Help me out! Thanks!!

**AliGW** · 04-16-2014, 09:48 AM

Tab 6 opens top left here. Usually, clicking on A1 before saving the file will ensure that this happens.

**AliGW** · 04-16-2014, 09:50 AM

=if(isblank(v7),"",if(v7<u7,"x",""))

pasted into AB7 on Tab 6 and copied down.

=IF(V7="","",U7-V7)

pasted into AB7 on Shortage and copied down.

And into U7 on Shortage:

=IF(ISBLANK('Tab 6'!U7),"",IF('Tab 6'!V7<'Tab 6'!U7,'Tab 6'!U7,""))

and into V7:

=IF(ISBLANK('Tab 6'!V7),"",IF('Tab 6'!V7<'Tab 6'!U7,'Tab 6'!V7,""))

both copied down.