I don’t understand your example but here is a formula you can adapt if you have
the analysis toolpak
=MAX(0, MIN(EOMONTH(F$1,0), $B2) - MAX(F$1, $A2) + 1) * $C2 / $D2
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Dhanesh Verma
Sent: Monday, May 21, 2012 7:13 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Appropriate formula required
Dear Friends,
In the attached list the total monthly allocations is more than the total
amount to be allocated, please suggest a suitable formula to compute the same.
R’gds
Dhanesh
DISCLAIMER AND PRIVILEGE NOTICE : This e-mail and any files transmitted with it
contain confidential, copyright, proprietary and legally privileged
information. It should not be used by anyone who is not the original intended
recipient. Any use, distribution, copying or disclosure by any other person is
strictly prohibited. If you receive this transmission in error, please notify
the sender by reply email and then destroy the message. Opinions, conclusions
and other information in this message that do not relate to official business
of DEN Networks Ltd., its subsidiaries, holding companies i.e. DEN shall be
understood to be neither given nor endorsed by DEN. Internet communications
cannot be guaranteed to be timely, Secure, error or virus-free. The sender does
not accept liability for any errors or omissions."
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com