To test if a cell is equal to a given value, you can use the IF function. In the example shown, the formula in cell F5 is: =IF(C5="red","x","") The result in cell F5 is "x" since the color in cell C5 is equal to "Red". The result from IF can be adjusted as needed. See below for a formula to increase the price of "Red" items by 10%.

To create a formula with a dynamic sheet name you can use the INDIRECT function. In the example shown, the formula in C6 is: =INDIRECT(B6&"!A1") Note: The point of INDIRECT here is to build a formula where the sheet name is a dynamic variable. For example, you could change a sheet name (perhaps with a drop-down menu) and pull in information from different worksheet.

To test a condition, and take one action if the condition is TRUE, and another action if the condition is FALSE, you can use the IF function. In the example shown, the formula in cell E5 is: =IF(D5="S","Small","Large") As the formula is copied down, it returns "Small" when the value in column D is "S" and "Large" when the value in column D is "L". Note that text values within the formula must ...

To combine or concatenate ranges in Excel with a formula, you can use the VSTACK function or the HSTACK function. In the example below, the formula in cell F5 is: =VSTACK(range1,range2) where range1 (B5:B8) and range2 (D5:D9) are named ranges. The formula appends the second range to the first range and the result spills into F5:F13. Note: Before the VSTACK and HSTACK functions where introduced ...