Hi everyone,
Thanks in advance for looking at this, here is a quick run down.
I have a spreadsheet that monitors production units required for a given week in Column "F".
The next column "G" has what was actually produced in it.
The next column "H" has the difference between the two. If the amount in Column G is less than or equal to 95% of the required production "F", the shortage is recorded in column "I" ( it will be added to the next weeks upcoming production (manually)- please see formula below.
This upcoming weeks order is pulled into column "J"
If the amount in Column G is greater than or equal to 110% of the required production "F", the overage is recorded in column "K" ( it will be deducted from the next weeks upcoming production (manually)- please see formula below.
I would like to combine the two criteria into one column if possible.
Formula in cell "I"
=IF(H9>0,"",(IF((H9*-1)>0.04999*F9,-H9,"")))
Formula in cell "K"
=IF($B9="","",IF(H9<0,"",(IF(H9>0.09999*F9,-H9,""))))
Thanks in advance for looking at this, here is a quick run down.
I have a spreadsheet that monitors production units required for a given week in Column "F".
The next column "G" has what was actually produced in it.
The next column "H" has the difference between the two. If the amount in Column G is less than or equal to 95% of the required production "F", the shortage is recorded in column "I" ( it will be added to the next weeks upcoming production (manually)- please see formula below.
This upcoming weeks order is pulled into column "J"
If the amount in Column G is greater than or equal to 110% of the required production "F", the overage is recorded in column "K" ( it will be deducted from the next weeks upcoming production (manually)- please see formula below.
I would like to combine the two criteria into one column if possible.
Formula in cell "I"
=IF(H9>0,"",(IF((H9*-1)>0.04999*F9,-H9,"")))
Formula in cell "K"
=IF($B9="","",IF(H9<0,"",(IF(H9>0.09999*F9,-H9,""))))