Hi
In the attached sheet I have given scenarios where a formula should return a result based on whether a cell has a positive value.
The formula is to first find the last cell in a range and return a 1 if it is a positive value, it then looks at the next cell before it and retun 2 if that cell is also positive and so on....
If the last cell is negative then it return 0 if the cell before it is positive it should still return 0.
If the last cell is positive and the cell before it is negative and the next cell before it is positive the formula should only return 1
This is explained more clearly on the spreadsheet.
Thank you for your interest.
Bookmarks