•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trying to make a FIFO formula
I’m new to excel and I tried to do my best on my own for creating a FIFO formula. The issue is that a sale will continue spilling over for the same amount and not what would be remaining for the next to takeout. I’ve tried my best but can’t figure out how to fix it. For example a sale for one part for a qty of 200 would pull from the earliest one correctly but it would continue to display 200 on the next ones as well without it running out.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#AI formula generation techniques
#rows.com
#formula generator
#FIFO formula
#Excel
#sale
#quantity
#spilling over
#pull
#part
#remaining
#display
#issue
#fix
#takeout