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?
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
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