Get HR Software

No Tags Found!


Excel Formula Troubles in Merged Columns: How Can I Automate Amounts and Words?


I am facing a formula insertion problem in Excel merged columns. Please go through the attached file and give your valuable suggestions. I require automatic amount and automatic words in the merged column.

Regards
From India, Guntur
Attached Files (Download Requires Membership)
File Type: xls FORMULA REQUIRED.xls (28.5 KB, 4334 views)

Acknowledge(0)
Amend(0)

PFA the required Formula .....
From India, Chennai
Attached Files (Download Requires Membership)
File Type: xls 56924-ms-excel-manuals-zip-download-excel-formula.xls (1.27 MB, 2245 views)

Acknowledge(1)
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.

Other Discussions That May Be Relevant
Optimizing hr functions with an mis sheet and excel formulas in a manufacturing plant
Hi i am sharing a mis sheet. please give me more input or ideas. i am working in a manufacturing plant where the total manpower is 400. so this is...
4 Replies 2 Files 3 Participants
Excel shortcuts and formulas compilation for enhanced excel usage
Hi all i hope the attachment will be useful to all of us. regards aftab...
13 Replies 6 Files 14 Participants
How to generate salary slips automatically using excel
Dear friends i am using excel to prepare salary statements. i want to know how excel can be used to prepare payslips automatically. can anyone tell me the process or...
5 Replies 1 Files 6 Participants
Excel tips, functions, and data manipulation techniques - comprehensive guide
Dear team please find the attached excel formulas & menu sheet. it will be useful for your calculations. thank you....
13 Replies 5 Files 11 Participants
Excel salary calculation formulas for pf - assistance provided
Hi i am working on salary calculations in excel and facing an issue regarding pf calculation. we have set our basic salary at 6500 for 30 days for employees whose...
5 Replies 1 Files 6 Participants
Excel software for compound interest calculation: tips and formulas
Excel software. if i have invested 5000 on 13.11.2005 for 3 years what will be the interest separately for every year quarterly compounded? something i want like as below. int...
3 Replies 1 Files 3 Participants
Comprehensive excel directory and formulas guide for learning resources
Hi all please find the attached excel file directory; it is very useful. cheers keyran...
9 Replies 3 Files 7 Participants

Related Files & Downloads Shared By Members
 Excel Functions Dictionary.xls
 Excel Formulas.xls
 Excel Formulas.ppt


Human Resource Management (HRM) Community Journal & KnowledgeBase (Entry: 507366)

India, Guntur
24 September 2014 10.39.26 AM
Views: 9358 Replies: 1 Appreciations: 1

TOP ENTRIES ON SUBJECT

Excel Formulas
Salary Slip In Excel Or Word - Excel Download
Calculation Of Overtime Hours In Excel Sheet - XLS Download
How To Calculate Salary In Excel - Xls Download
Excel Formulas And All Options - Xls Download
Number To Word Converter Software In Excel - XLS Download
Enhance Age Calculation With Excel Formulas: Excel Sheet For Data Manipulation


Excel Functions
How Excel Is Used In Hr Function - Pdf Download
Utilizing Excel In HR: Functions, Tips, And Data Analysis Insights
Microsoft Excel Shortcut Keys - Pdf Download
How To Calculate Total Hours - Xls Download
Enhancing Efficiency: Computer Shortcut Keys, Excel Functions, And Employee Rights Discussed
Vlookup N Pivot Table(plz Need Help) - PPS Download





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.