I have excel worksheet in which rice and salt is distributed to students every day. In that sheet calculation is done every day. I want to stop the calculation when balance of rice or salt becomes zero or negative number. Can anyone suggest me a vba code or any formula.I am attaching sample excel file. I think I have described well in that file. Please help me.
try this uses max() formula in cells f24.h24 and conditional format to amber when running total exceeds stock also red when total exceeds stock
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
This can get you started.
J6=if(SuM($F$6:F6)>$F$4,"",SuM($F$6:F6))
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
hi Martindwilson,
your formula shows red colour but when rice or salt is not in balance we cannot show the numbers for distribution. the values for red coloured portion should be either blank or zero. i.e. the formula that is present in that red cell should not work. thankyou very much.
Last edited by excellover2212; 09-01-2013 at 07:06 AM. Reason: respect
hi oeldere,
you have given right formula but the cell f6 contains a formula already. i want to do that as soon as the balance of rice becomes zero or negative the formula in the cell in F column should not work. Thank you.
try in f6
=IF(C6*0.5+SUM($F$5:F5)>$F$4,0,C6*0.5)
Dear martind wilson
thank u very much. your formula works correctly. you are genius.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks