Show image in cell based on cell value
- by JoeM
I am creating a weekly income comparison table. I want to compare A5 and A10 cells and display appropriate image in B7 cell. The image will be either UP or DOWN arrow (which reflects increase or decrease).
I've created a formula which puts text up or down in the cell, but I don't know how to replace it with the up/down image.
=IF(D77>D69, "up", IF(D77<D69, "down"))
How can I do it? I know it's possible.
Note: I am using Google Docs Excel, so please let me know if this cannot be done in it, but I have to use the real Excel installed on my laptop.