I have an excel workbook which includes the following –
- Row 1 Border
- Row 2 Column Header Group
- Row 3 Column Header
- Rows 4 – 29 are the data
- Column C is a variable (Buy, Hold, Sell) Again C3 is the column Header.
- Column O is the 5 Day Daily Percentage Change (O3 is the header)
- Column U is the 5 Day Score (U3 is the header)
The first thing I want to do is set the values in C4 – C29 to Sell WHERE the values in O4 – O29 are less than 1.00
Set the values in C4 – C29 to Sell where the values in C4 – C29 ARE NOT ‘Sell; AND O4 – O29 <= 2 Next Set the values in C4 - C29 to Buy where the values in C4 - C29 ARE NOT 'Sell; AND O4 - O29 > 3
Please, can you guide me on how to do this?