I have a spreadsheet where I use a simple subtraction formula to compare a current value to a previous value. If the value has increased the number returned will greater that zero, less than zero if the value has gone down and zero if it has not changed.
In the next column I need a formula to show an R for any number above 0, an L for anything below 0 and an E for a 0.
rle.jpg
Thanks for any suggestions.
TT
Bookmarks