Please Scroll Down to See Forums Below
Ms Excel
- Thread starter Cutiebaby
- Start date
something like this?
Holy shit Lestat this is perfect..Only one thing is that each row the minimum order and on hand orders change. They do not stay at 45. So do I use the cell for instance C4 instead of saying 45?
I will try to post spread sheet.
Yes, in my forumula I did not hard code any values, they are all relative, so it will compare whatever values you populate in the columns.
This is what I have to do next
Orders are placed if the amount on hand is less than half the minimum order amount. Use a function in cell B5 to return a “Y” if the amount on hand is less than half the minimum order amount and an “N” if the amount on hand is more than half the minimum order amount.
Orders are placed if the amount on hand is less than half the minimum order amount. Use a function in cell B5 to return a “Y” if the amount on hand is less than half the minimum order amount and an “N” if the amount on hand is more than half the minimum order amount.
Lestat thank you.......I got it to display by using =if(c5<d5/2,"y","n")
but now i need to
10. The order amount column needs to reflect the amount in the minimum order column only if the corresponding Order Y/N entry in column B is Y. Use a function in cell C5 to return an “NA” if an order should not be placed and the minimum order amount from column D if an order should be placed
but now i need to
10. The order amount column needs to reflect the amount in the minimum order column only if the corresponding Order Y/N entry in column B is Y. Use a function in cell C5 to return an “NA” if an order should not be placed and the minimum order amount from column D if an order should be placed
Done.
See the formula?
=IF(C5<(D5/2),"Y","N")
Where column C is the amount of on and column D is the minimum order amount.
Done.
See the formula?
=IF(C5<(D5/2),"Y","N")
Where column C is the amount of on and column D is the minimum order amount.
see post #36
Razorguns
Well-known member
Similar threads
