problem calculating a cell based on the specific content of another cell

[mikerules]

I am designing an order form and need to calculate the quanity of an item to order based on min OH as well as current ON

Cell A = qty min on hand (this is a sum of a range of cells)
Cell B = current on hand quanity (this is a sum of a range of cells)
Cell C = order quanity


So lets say I want to maintain a min 5 units so 5 is in A
I add that I have 2 units currently so 2 is in B
Cell C adds A - B and populates 3 in C as the order qty

This works great except that when the form has not been used col B is showing 0 as the range of cells it is adding is blank. As a result the max of 5 is being ordered in cell C instead of zero as it should be.

What I need is the above equation works except when b is blank in which case C will equal O

I can email a copy if someone can help me out but can't understand what I am saying here

mike

[vlady]

you can post it here "without the sensitive data's "

or maybe issue an if statement

in C =if(B=0,0,compute for c)

[mikerules]

Thanks for your answer. I was wondering if there is a way to prevent an entry in a cell where another specific cell is blank (not populated)

In cell A I show 10 which is the most that can be ordered in Cell B but if A is blank then I don't want B to be populated

[vlady]

You can also do as above

=if(A1="","",compute for B)
or
=IF(ISBLANK(A1),"",compute for B)

if your entering B manually data validation can do that in data validation - custom =A1<>""

[mikerules]

omg I am confused!! I have attached a copy of the file is it possible on here to modify a cell to show me what you mean?

[vlady]

i have problems in uploading but here's your answer..

In cell Test Order Form.xlsx

[mikerules]

Thanks I got your result. The problem and I am not sure if it can be fixed is that how you have it set up requires me to put a number of some sort in each yellow cell where i have a number in the cell to the left because if I don't the entire qty gets ordered.

As you have it set up when I open the sheet to place an order it starts with an on order qty of the entire qty possible to order which is very confusing.

[vlady]

in H13 =IF(K13>0,(J13-K13)*F13,0)