Hi all,
Currently I have managed to create an IF statement to determine the output within my cells depending on the quantity and lead time stated - so in this case the quantity you see is 6 and the lead time is 1-2 Weeks. If I were to change the quantity to 10, it would give me different results.
I'm trying to make it look at different lead time options to determine the output it gives. So at the moment it is just looking at 1-2 Weeks data but i am unsure how to get it to look at this as well as 2-4 weeks data. I have 'prices' for the 2-4 lead time for it to lead from.
Any ideas on how I can get an output that is determined by the lead time i enter? It needs to look at both options.
Does this make any sense? haha
TIA
