I'm trying to create a formula to calculate the # Hours per remaining week based off the total HOURS remaining. Calculation takes into consideration the calculated remaining # of weeks on a project. Logic should be: Take Remaining hours / # of remaining weeks. If remaining weeks is < 1, simply return the amount of remaining hours.
The current formula below I have is calculating correctly when the Remaining (Weeks) is 1 or more. However, once the Remaining (Weeks) is less than 1, the returned value is incorrect and I cannot figure out WHY it returns this odd 1125 value.
Formula: =IF([Column2]9 > 0, [Column3]@row / [Column2]9, MAX([Column3]@row, 0))
In this example, # of remaining weeks is 3.3. Therefore, the Remaining Per Week is 97.8 (321.5/3.3)-> Correct calculation
Second Example: Here, using the same formula but when the Remaining (Weeks) is < 1, it keeps returning a value of "1125" which I cannot figure out why. What I want it to return is the Remaining Hours of = 321.5 - the value in Column3@row. Tried writing this in different ways, and keep getting same odd value. Any idea and help would be great appreciated. Thank you
