Excel equation

[Closed]
Report
Posts
1
Registration date
Tuesday March 11, 2014
Status
Member
Last seen
March 11, 2014
-
Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
-
i want to formulate for eg:-

inv date pymt terms amount payment due date jan feb mar apr

01.01.2014 30 1000 31.01.2014


so if invoice payment is due on jan i need to go that particular invoice amount to that coloum of that particular month in the right corner .how can i solve this please give me an answer

1 reply

Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
482
Hi Sree141,

For the "jan" column use:
=IF(MONTH(D2)=1,C2,"")
Where D2 is "payment due" and C2 is "amount".

Change the 1 in the formula into 2 for the "feb" column etc....

Best regards,
Trowa