Using an IF statement in Excel is simple once you break it down into simple terms. If a condition is true, it should return X; otherwise, it should return Y.

How to insert a transparent image into an Excel document; How to apply if function in Excel: with dates, with text; How to change enter key function in Excel; Insert picture in Excel: cell, shortcut, ...

By using an IF statement to prevent Excel from dividing any of the funds collected by zero, only the valid numbers are calculated. JD Sartain / IDG Worldwide.

Logic statements use the "IF" function, displaying one result if cells meet certain criteria and a different result if they don't. Type the following formula into an Excel cell:=IF(Sheet1!F3 = 8 ...

So cleverly, instead of forcing you to return a hard value such as 3, Excel lets you use this false field to test another condition using a nested IF statement. In this case, if A1 is equal to 13 ...

Excel - problem with ... or the fact that the data is unsorted.<br><br>Perhaps I should be using INDEX or MATCH but I'm not clear on how to correctly incorporate them within the IF statement.