IF

A

Ahmad Assaf

Hi everyone,
I need the create a formula as the following:
Input cell any number
Items cells 2 or 3
Capacity of the Items 4 or 8
QTY ?????

The Input should be divided by the QTY of the Items for
examble Input 12 divided by 8 = 1.5

The QTY should be 1 from item1 and 1 from item2

Thanks and best regards,
Ahmad
 
Top