I am trying to have excel automatically enter my order. Example I am ordering chicken inventory is 2 my par is 6 I need it to enter and order of 4. If my inven. is 8 and my par is 6 then it will show up as order of 0 or a blank cell. Thank you in advance for your help.
Jeff
Last edited by jeffpanagos; 09-04-2012 at 11:22 PM.
maybe with if??
ordercell=if(invencell > parcell ,0,parcell-invencell)
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
That works!!! Thank you very much. This was driving me crazy. Great Forum!!
Your welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks