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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 11, 2014 at 11:24 AM
Related:
- Excel equation
- Excel date format dd.mm.yyyy - Guide
- Equation editor free download - Download - Word processors
- Transfer data from one excel worksheet to another automatically - Guide
- Number to words in excel - Guide
- Screenshot in excel - Guide
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
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
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