I am placing orders based on excel calculations - however frequently getting below error for about every 2 out of of 10 orders. "Price is 0 or invalid or negative" (As per debug file) I am assuming that this will happen when order function is referring to a cell where calculation is in process? can you please advise how to ensure this doesn't happen?
@impratikthakkar Are you passing price from referring other cell? If that's the case, then your placeorder formula is called before your price formula.
You can add a IF to check for zero price Example: Cell A1 = Some Formula which returns price Cell B1 = IF(A1 > 0, PlaceBO(......A1.......), "NA")
Thank you so much I had read the same website but could not figure out the calculation order in excel! I modified the formula code as suggested - lets see if error is fixed when implemented in live market.
Are you passing price from referring other cell?
If that's the case, then your placeorder formula is called before your price formula.
You can add a IF to check for zero price
Example:
Cell A1 = Some Formula which returns price
Cell B1 = IF(A1 > 0, PlaceBO(......A1.......), "NA")
A wonderful website to know more about excel calculation etc
http://www.decisionmodels.com/calcsecretsc.htm