If the value in the Day cell is 'Wednesday', then the result will be Yes.Otherwise the result will be No, as it is in this case.There are many ways to use the IF() function in Excel that we won't cover here, but look out for more advanced IF() lessons coming soon.In order to reference a cell on another sheet, instead of using: =A1 Here is the simple formula to check if cell contains specific text or not. You can search for a text and return the required values (for example: Yes, No), if finding text existing in within cell. IF Formula IF (logicaltest, valueiftrue, valueiffalse) The function uses the following arguments: Logical test (required argument) This is the condition to be tested and evaluated as either TRUE or FALSE. IF (COUNTIF (A2,'Specific Text'),'Yes, it is Found', 'Not Found') Here COUNTIF function determines if a specific text exist in a Cell. Value iftrue (optional argument) The value that will be returned if the logicaltest evaluates to TRUE. So in order to build your IF statement, you would build it like another other if statement, you would just need to include the sheet name with the cell reference for those cells located on other worksheets.Īs an example in order to pull the value from B3 on sheet3 when the value of the current sheet cell M42 is TTT, but to pull the valus from A1 on the BRAINS sheet it would look something like: =IF(M42='TTT','sheet3'!B3,'BRAINS'!A1) So if we want to reference A1 on another sheet we use: ='another sheet'!A1 You need to include the sheet name in front of it. The IF function is made up of three parts: When you enter the formula above with a nested IF statement, Excel reads the first IF statement. It looks at your criteria, then the outcomes for the criteria. The logical check, conditional check, what ever you want to call it that resolves to either TRUE or FALSEĮach to the parts is separate by a comma and looks like this in the general sense: IF(CONDITION CHECK, TRUE action, FALSE action).Now if you do not put the FALSE action in, and the condition check returns false, then the result of your IF function will display FALSE.

If then formula excel