Not sure what you mean by 'absolute of 100'
In C7 enter
=C5+C6

In C8
=IF(C7<100, 100-C7,"")

In C9
=IF(C7100, C7-100,"")


"Mike" wrote:

I am trying to make a formula that shows overage and underage.
For Ex. C7 should be an absolute of 100 but show the total of cells C5 and C6.
But if this total is less than 100 ( for ex. 89) then I need cell C8 to show
how much
less than 100 it is( ex. 11) and I need cell C9 to show how much over 100
( Ex. C5+C6=115 then cell C9 should show 15).
Any help would be greatly appreciated. I am very new to this.