IF

  • Thread starter Thread starter Ahmad Assaf
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GETPIVOTDATA #REF! error XL2003/2010 1
Export as XML for an Excel Order form document 1
List those which are selected 9
Copy and Fill to another column 5
Change the data in one cell based on content of another. 2
Move data from one line to another 2
how to lookup a value for a value 3
PivotTable Calculations 12

Back
Top