close
I've used Excel for over 15 years, but haven't had to deal too much with
functions and lists. I have If Statements embedded in a column that returns
an quot;on timequot; value for any ship date that is less than the due date. What I'd
like to do if this statment is not true (value_if_false), is have the cell
prompt the user with a picklist of 2 values to choose from, from there, I
think I can handle the rest of the functions needed (i.e., count, sum)to
calculate to determine percentage of items shipped on time). Your advice and
assistance on this would greatly be appreciated.
全站熱搜
留言列表
