LinkBack URL
About LinkBacks
c25=if($A25>C$4,"",if($A25=C$4,$B25-($B25/$A$1),MAX(0,if($A25<=C$4,B25-($B25/$A$1),"")))) and drag across.
See the attached file.
c25=if($A25>C$4,"",if($A25=C$4,$B25-($B25/$A$1),MAX(0,if($A25<=C$4,B25-($B25/$A$1),"")))) and drag across.
See the attached file.
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,
Thanks for the replying but I am not getting the same results as I was getting with manual formulas.
There should be amount in last month. For example, January 2017 amount should end in December 2017 and February 2017 amount should end in January 2018.
Can you please take a look again and let me know.
Thanks again,
Jai
One way in C6 dragged across and down
Formula:
=IF((9-ROW($C9))-(3-COLUMN(C$9))>=0,ROUND($B6-($B6*MAX(0,COLUMN(C6)*2-5-(ROW(C6)-6)*2)/24),0),"")
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks