Forum Discussion
DanaStoltzner
Apr 15, 2024Copper Contributor
Two wrongs don't make a right - Negative Worker Values Are Turning into Success
Greetings: Contrary to mathematical principles, I am exerpiencing something in the real world that I cannot solve or figure out how to do correctly in Excel. Lets start with the quandary: ...
DanaStoltzner
Apr 15, 2024Copper Contributor
Thank you. There is that idea-much appreciated. The one issue is that I was trying to create a blanket algorithm for whole sections of the spreadsheet and I never know when I will get a negative. We have two hundred tomato pickers across 4 farms and I never know when A worker will go below standard productivity and I am responsible for supplying the spreadsheets daily. It would be nice to not have to check ever day, every section for double negatives that end up positive and look like success. I have to subtract primary to get to a productivity value on positive numbers, so how do I do addition and subtracting at the same time in the same algorithm. Like I said, I am not an advanced user, but the document is complicated. Thank you for your help. Best, Dana.
HansVogelaar
Apr 15, 2024MVP
We may be able to help you better if you show us some of the layout and of the expected result...
- DanaStoltznerApr 15, 2024Copper Contributorsounds good. Please forgive my novice nature with this tech. How would I show you the layout? I don't see any option to add an image or file. Open full text editor?