ExcelBanter - Help with formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help with formula (https://www.excelbanter.com/excel-discussion-misc-queries/178406-help-formula.html)

Richard

Help with formula

I'm using this formula to track how many parts are sent to assy in C3.
=IF(B3="","",SUMIF('Sent to Assembly'!A:A,A3,'Sent to Assembly'!B:B)). What
I'm trying to do is take the results from this formula and subtract the
results from B3. But once it reaches or excedes the qty needed in B3 show "0"
or "Order Complete". Thanks in advance!!

JMB

Help with formula

you could try
=IF(B3="","",MAX(B3-SUMIF('Sent to Assembly'!A:A,A3,'Sent to Assembly'!B:B),
0))

"Richard" wrote:

I'm using this formula to track how many parts are sent to assy in C3.
=IF(B3="","",SUMIF('Sent to Assembly'!A:A,A3,'Sent to Assembly'!B:B)). What
I'm trying to do is take the results from this formula and subtract the
results from B3. But once it reaches or excedes the qty needed in B3 show "0"
or "Order Complete". Thanks in advance!!

All times are GMT +1. The time now is 10:22 AM.