Using IF Function
=IF(SUM(B16:B19)48,SUM(B16:B19)-48,SUM(B16:B19))
Substitute your range of cells as required.
"pjb" wrote:
I am trying to create a formula that will sum a list of cells and if the
total exceeds a certain number it will return the number that is above that
number. ie:sum = 48, I want the formula to show 8. thanks
|