Microsoft Office Word Excel Access PowerPoint Outlook Project VB training in Leeds Yorkshire uk programming SEO Data Recovery and Online Backup

Home

Database Design

Training

SEO

Spreadsheets for IFAs

Blog


	Outlook Reading Pane Disabling the Word 2007 Mini-Toolbar Excel Sheet Navigation 4Networking in Leeds East Twitter - ReTweets Twitter - Lists Twitter - Mobile Excel Paste Column Widths PowerPoint Slide Master Windows 'God Mode' Excel Functions Filling Alternate Cells Microsoft Office Shortcut keys Excel Negative Times Word Reading Layout Windows Shortcuts Excel dropdowns Quick sheet selection Search files on Google A - Z of Excel Word 2003 to 2007

Astradyne Blog - A to Z of Excel - I

I is for INT, IF

In Excel, the Int function returns the integer (whole number) portion of a number. Be careful though, as if the number is negative, the INT function will return the first negative number that is less than or equal to the number.

Borders

The IF function makes a decision regarding values. For example:

Borders

The formula in C2 translates as

If A2 is equal to B2 THEN say "Yes" ELSE say "No"

I like to read the commas as THEN and ELSE. Text answers must be placed in quotes (")

<-Previous (H) Next (J)->

vb training leeds, vba training leeds, excel vba, access vba, pc training in leeds, computer training in yorkshire, pc training in yorkshire, computer training in leeds, microsoft access vb, microsoft excel vb training, microsoft powerpoint training, microsoft training, microsoft word, office 2000, excel training leeds, access training leeds, office training leeds, office 2007, leeds vba, leeds visual basic, leeds training