IF Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to create an IF statement whereby if a certain stock in my portfolio goes up for that day's activity, it will display a green up arrow; if it goes down, a stick person dangling at the end of a rope. (Just kidding about that one). The GIF pictures I want to use will be in the same subdirectory as the Excel spreadsheet. I'm using Excel 2003.

Thanks in Advance!!
Ron_D
 
If you would care to use the WingDings font instead of a
GIF, try this:

=IF(K3>1," J",IF(H3>F3,"K","L "))

Then format the result as WingDings. You get either a
smile, a frown, or neutral.

Alan
-----Original Message-----
I'm trying to create an IF statement whereby if a certain
Click to expand...
stock in my portfolio goes up for that day's activity, it
will display a green up arrow; if it goes down, a stick
person dangling at the end of a rope. (Just kidding about
that one). The GIF pictures I want to use will be in the
same subdirectory as the Excel spreadsheet. I'm using
Excel 2003.
 
Back
Top