IF statements are a powerful tool to compare information within Excel; however, nesting IF statements, that is building IF statements that continue to compare within the same statement, provides a mechanism for advanced scenarios with layers of comparison.
In this recipe, you will create a multiple nested-IF statement to compare stock price deviation daily and by a weekly average.
The following worksheet provides relative stock price fluctuation. Poor selling price is determined by taking the starting number and determining a negative deviation of more than $0.75; however, even if the deviation is greater than 75 cents, if the deviation is less than $1.75 from the weekly average stock price in cell B1, then the fluctuation is acceptable.
1. Starting in cell B3, enter the following comparison IF statement formula, then press enter:
=IF((A3-$A$2)<-0.75, IF((A3-$B$1)<-1.75,"Bad","Acceptable"), "Good")
2. Copy cell B3's formula into all remaining...