Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


    Copyright
    Acknowledgments
    Introduction
    Ch. 1. Formulas in Excel
    Production per hour
    Calculate the age of a person in days
    Calculate a price reduction
    Convert currency
    Convert from hours to minutes
    Determine fuel consumption
    Calculate your ideal and recommended weights
    The quick calendar
    Design your own to-do list
    Incrementing row numbers
    Convert negative values to positive
    Calculate taxes
    Combine text and numbers
    Combine text and date
    Combine text and time
    A special ranking list
    Determine the average output
    Stocks — gains and losses
    Evaluate profitability
    Determine percentage of completion
    Convert miles per hour to km per hour
    Convert feet per minute to meters per second
    Convert liters to barrels, gallons, quarts, and pints
    Convert from Fahrenheit to Celsius
    Convert from Celsius to Fahrenheit
    Calculation with percentage
    Monitor the daily production plan
    Calculate number of hours between two dates
    Determine the price per pound
    Determine how many pieces to put in a box
    Calculate manpower required for a project
    Distribute sales
    Calculate your net income
    Calculate percentage of price reduction
    Dividing and doubling every three hours
    Calculate the average speed
    Ch. 2. Logical Functions
    Ch. 3. Text Functions
    Ch. 4. Date and Time Functions
    Ch. 5. Basic Statistical Functions
    Ch. 6. Mathematical Functions
    Ch. 7. Basic Financial Functions
    Ch. 8. Database Functions
    Ch. 9. Lookup and Reference Functions
    Ch. 10. Conditional Formatting with Formulas
    Ch. 11. Working with Array Formulas
    Ch. 12. Special Solutions with Formulas
    Ch. 13. User-defined Functions
    Ch. 14. Examples
    Index
    • Create BookmarkCreate Bookmark
    • Create Note or TagCreate Note or Tag
    • PrintPrint
    Share this Page URL
    Help

    Chapter 1. Formulas in Excel - Pg. 1

    Chapter 1 Formulas in Excel