TrimPath Forum

cos I'm a pesterer and don't think you saw the follow-up question in my other thread:

will it ever be possible to display images based upon conditional operators?

For example, my ongoing spreadsheet project is a weightloss tracker and I'd like to display a picture according to where my weight stands (with the picture being a fat me or a thin me - yeah...I know...). Currently I can quite simply use something to the effect of:

=c8 < 168 ? "doing well" : "you fat blob"

to achieve this in text form. But if I were to replace them with:

=c8 < 168 ? "<img src='insert thin image here'>" : "<img src='insert fat image here'>"

it merely prints those urls out. I do understand that the parsing engine might need an overhaul in order to even think about this type of functionality, but it's worth me putting it out there anyway.

Another useful function would be to find what the last value (positionally rather than maximum or minimum) in a row or column is. As it stands I have to change the cell reference containing my current weight each week, which is a minor irritation. I don't know how hard it would be to implement, but some sort of =last(c) function would be such a convenience.

Again, I do appreciate the work you put into this project and thank you for the time taken to read these ramblings