ITEM | DATABASE 1 | DATABASE 2 | DELTA |
TRUCK STAKE 6X6 46000 GV | 183 | 184 | 100.55% |
TRK STAKE 46000 GVW | 161 | 161 | 100.00% |
TRK SUV 8600 | 160 | 152 | 95.00% |
A formula for all cells under the delta. If both databases match, they should be at 100%. Trying to get the inventory delta to reflect a percentage, regardless of which database has more items. None of the results should be over 100%. I started with a formula from your site. =IF(B2>B3,+B2-B3, B3-B2). | |||
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>