Quote:
|
=IF(Bn<=En*7,"BUY="&ROUNDUP(SUM(SUM(En*7)-Bn)/En,0)),"IN STOCK"))
|
If that works for you, ok (I have a ton of stuff to do today so I won't try too hard to check), but you don't need the SUM functions there. The same thing happens without them:
Code:
=IF(Bn<=En*7,"BUY="&ROUNDUP((En*7-Bn)/En,0)),"IN STOCK"))
No, wait, there's a problem here. In column E, I have eight days' supply already. The whole point of doing that is not to have to repeat the multiplication in the IF function. If you don't want to have the extra column E, then you multiply by D instead.
06-23-2014, 05:13 AM
Similar Threads
if statement
Windows 7 64bit 
Office 2010 32bit
Threaded Mode