I am working on a complex conditional equation where if a cell = no then do this but if the cell is yes, and a second cell is greater then zero do this but if the second cell is less than zero do that.
The attached file has some play data. I can get all of them except when the Adj Need < 0. Does anyone have any suggestions for a single formula that I can use in all cases to compute the over amount? In the excel file below, the over amount for item 4 is wrong.
The attached file has some play data. I can get all of them except when the Adj Need < 0. Does anyone have any suggestions for a single formula that I can use in all cases to compute the over amount? In the excel file below, the over amount for item 4 is wrong.
Comment