Forum Discussion
Solved
SUM formula help needed with multiple criteria
Having difficulty with the following:
IF the sum of cells G5:G10 exceed the value of cell G16, then I need to enter the sum of G5:G10 minus G16, otherwise a zero if the sum is less than G16. T...
Like
=IF(SUM()>30000,30000-G16,IF(SUM()>G16,SUM()-G16,0))
Like
=IF(SUM()>30000,30000-G16,IF(SUM()>G16,SUM()-G16,0))