Formula HELP!!

M

Mike

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.
 
S

Sheeloo

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

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

In C9
=IF(C7>100, C7-100,"")
 
C

Chris Bode via OfficeKB.com

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(C7>100,C7-100,"")

Now you are done!

Have a nice time


Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top