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))
Alex,
for calculating commission you should have a look at Mike Girvins YouTube channel. He has done some videos about the topic.
He has some interesting things on his channel. Thanks for the heads up!
