Hello!
I have a worksheet that makes calculations in cells based on the outcome of a calculation or input in another cell. If an input cell is empty it throws off the whole calculation cycle.
Here's a little more information:
Cells A5:D5 receive operator input of a quantity for items, if each item is ordered.
Cells A7:D7 divide the number in Cells A5:D5 by a number in A6:D6
Then those numbers in cells A7:D7 are added up in Cell G5.
If there is no amount put in any one or more of the cells A5:D5 (because no one ordered that item), it throws the whole calculation off and all you get is “#DIV/0!”
Looking through HELP, I believe it has something to do with “ISERROR” but, unfortunately, I am too ignorant to understand how to use it.
Here are the actual formulas I have for 1 column:
A5 = operator input (# of items ordered)
A7 = =ROUNDUP(A5/A6,0)
A46 = =ROUND((PRODUCT(A7,0.65)),1)
G5 = =ROUND(((PRODUCT(A6,A46)+PRODUCT(B6,B46)+PRODUCT(C6,C46)+PRODUCT(D6,D46))/1.72),1)
If A5 is blank, everything else reads "#DIV/0!"
Thank you so much for any help!
~Christy
I have a worksheet that makes calculations in cells based on the outcome of a calculation or input in another cell. If an input cell is empty it throws off the whole calculation cycle.
Here's a little more information:
Cells A5:D5 receive operator input of a quantity for items, if each item is ordered.
Cells A7:D7 divide the number in Cells A5:D5 by a number in A6:D6
Then those numbers in cells A7:D7 are added up in Cell G5.
If there is no amount put in any one or more of the cells A5:D5 (because no one ordered that item), it throws the whole calculation off and all you get is “#DIV/0!”
Looking through HELP, I believe it has something to do with “ISERROR” but, unfortunately, I am too ignorant to understand how to use it.
Here are the actual formulas I have for 1 column:
A5 = operator input (# of items ordered)
A7 = =ROUNDUP(A5/A6,0)
A46 = =ROUND((PRODUCT(A7,0.65)),1)
G5 = =ROUND(((PRODUCT(A6,A46)+PRODUCT(B6,B46)+PRODUCT(C6,C46)+PRODUCT(D6,D46))/1.72),1)
If A5 is blank, everything else reads "#DIV/0!"
Thank you so much for any help!
~Christy