Excel equation

Closed
sree141 Posts 1 Registration date Tuesday March 11, 2014 Status Member Last seen March 11, 2014 - Mar 11, 2014 at 09:52 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 11, 2014 at 11:24 AM
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

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
Mar 11, 2014 at 11:24 AM
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
0