Factoring A Quanity
Mar 16, 2008
I have a worksheet and trying to figure a way to check the users inputted quanties of items so they measure out correctly.
Example
A1 - user inputs quanity - 101
B1 - user picks description of item - Barricades
Barricades are 10' in length so the qty should be 110 not 101. Basicly a pop up message would do letting the user know the qty inputted is incorrect.
I have created a list of products and there factors just not sure how to set up the code to check it.
View 9 Replies
Jun 2, 2009
I'm trying to do is calculate pay for mileage while factoring in the number of participants. In other words, if the mileage was between 0 and 50 miles, and there were 5 or less people, then this cell should be $35.00. But if it's between 0 and 50 and there were more than 5, then this cell should display 175/the number of people (175 being 35 * 5). In other words, more than five people would receive an equal amount of the total pay for five people (this is because five people are the standard, but there are instances in which six or seven could participate and I was hoping to avoid hardcoding that).
The rest of the if statements simply follow that same formula, but for different mileage/pay rates.
View 6 Replies
View Related
