One of my friend asked me; how many IF statements can I nest in a cell?
Interesting, It is 64 IF statements in a cell (version 2007 and above)
In excel version 2007, a cell can contain up to 32,000 characters.
MS Office Tips, Excel Notes, Accounts, ERP, Use Excel, Professional tips, Training, Learning, Computer Basics, MS Excel, Spread Sheet, Data calculations, Formula, Functions, VBA, Visual Basic, Macro Codes
Post Labels
- Absolute and Relative references
- Charts
- Countif with format
- database function
- Date Function
- Find Duplicates
- Named Range
- Networkdays Function
- Pivot Table application
- Principle component in EMI
- Project Finance
- shortcut key
- Subtotal function Usage
- Text to column function
- Trend Application
- User Defined Function
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment