Dear Friends.
I am making a chart. It contains 3 subject
01. OT Forecast
02. Approved
03. Balance
* The Balance = OT Forecast - Approved ( this is my function)
* When I update the approved amount it will automatically deduct from balance...
Now I need a function for >
When the approved cell comes empty, the balance should show the "0"
but the total amount should be correct....
Sorry for my poor english ...
Irsaath
Last edited by irsath; 05-14-2007 at 03:53 AM.
Cell E8 =IF(C8,SUM(E7-D8),0) and copy it down.
Thanks for your help ...
But I am not satisfy with your answer..please check again the attachment ..
Irsath
Replace the formrr function I gave you with this one :
=IF(SUM(C8:D8),$E$7-SUM($D$8:D8),0)
Wow....great...1000 thanks dear...
But the Last cell "Total amount" is not appearing ...
It should show the total....
Please don't try to scold to me....
Irsath
=$e$7-sum($d$8:d20)
Thank you Mr, Winte...
You have done my task.....1000 of thanks for you .. If you know any site to learn about If function, please don't forget to share with me....
Irsath
You're welcome Irsath.
The IF statement only includes ( Condition A = B or A > B or A <> 0 , when True, when False )
The text in red is to explain.
Succes,
Erik
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks