Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2005
    Location
    Dallas, Texas, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding a graphic with an IF/THEN formula (Excel 2003)

    I would like to be able to add a formula that will insert an embedded picture in a cell if the condition is not met. For example:

    =if(A1=0,"Complete",picture.jpg)

    Does anyone know if this can even be done, and if so, what is the correct syntax for adding the graphic into the formula and embedding the graphic?

    Thank you in advance for your assistance. [img]/forums/images/smilies/smile.gif[/img]

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Adding a graphic with an IF/THEN formula (Exce

    See <post:=119,880>post 119,880</post:>

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Adding a graphic with an IF/THEN formula (Excel 2003)

    You might also look at the results to <post:=291,921>post 291,921</post:> which has an example file of a technique that might be adapted

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •