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.

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.

Please follow following steps
1.Select cell C7 and enter following formula
=SUM(C1:C6)
2.Select cell C8 and enter following formula
=IF(C7<100,100-C7,"")
3.Select cell C9 and enter following formula
=IF(C7100,C7-100,"")

Now you are done!

Have a nice time


Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200902/1