gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 660
- Office Version
- 2019
- Platform
- Windows
Hello,
If a cell in a range (B2:B8) is less than specific cell (E9), then divide specific cell by the cell less than specific cell value.
If no cells are less than, then "no cells".
Thank you.
If a cell in a range (B2:B8) is less than specific cell (E9), then divide specific cell by the cell less than specific cell value.
If no cells are less than, then "no cells".
Thank you.
The Whole Enchilada.xlsm | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Symbol | Price | QTY | Cost | if any cell in B2:B8 is > E9, then divide E9 by that specific cell in B2:B8 | |||
2 | UBOT | $22.74 | 14 | $318.36 | want to create quantity | |||
3 | CLDL | $6.25 | 44 | $330.00 | ||||
4 | ||||||||
5 | ||||||||
6 | ||||||||
7 | ||||||||
8 | ||||||||
9 | Total: | 58 | $648.36 | $14.81 | Total Remaining Funds | |||
10 | ||||||||
11 | 2 | expected result | ||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C9 | C9 | =SUM(C2:C5) |
D9 | D9 | =SUM(D2:D8) |
D11 | D11 | =ROUNDDOWN(($E$9/B3),0) |