Previous Topic Next Topic

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 December 27, 2022 - 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
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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

Similar discussions

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

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response