Previous Topic Next Topic

Excel equation

Closed
sree141 Posts 1 Registration date Tuesday 11 March 2014 Status Member Last seen 11 March 2014 - 11 Mar 2014 à 09:52
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 11 Mar 2014 à 11:24
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
Related:

1 response

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
11 Mar 2014 à 11:24
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Convert number to spelling
Sukumar -
mrwagh85 -

28 responses