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