• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Working with Functions > Using Advanced Functions

Using Advanced Functions

Calc offers numerous advanced functions that allow you to do very complex calculations. And while coverage of all the advanced functions is beyond the scope of this book, we will take a look at the IF function, and the LOOKUP functions (HLOOKUP and VLOOKUP).

To Use the IF Function

The IF function is a Logical category function that allows you to place conditional statements in your spreadsheets. These conditional statements can return text entries or values to the cell containing the IF function.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint