I have 2 pictures but only want to display one dependant on what infomation
is in cell a1 is this possible using a IF statement??

Not with a formula.

See John McGimpsey's site for a method using a Data Validation dropdown to
select an item which inserts a picture.

http://www.mcgimpsey.com/excel/lookuppics.html


Gord Dibben MS Excel MVP

On Sun, 1 Jun 2008 22:58:00 -0700, nivek05
wrote:

I have 2 pictures but only want to display one dependant on what infomation
is in cell a1 is this possible using a IF statement??

Hi,

I have 3 pictures but only want to display one dependant on what infomation
is in cell a1 is this possible using a IF statement??



nivek0 wrote:

can i insert a picture with a if statement
02-Jun-08

I have 2 pictures but only want to display one dependant on what infomation
is in cell a1 is this possible using a IF statement??

Previous Posts In This Thread:

On Monday, June 02, 2008 1:58 AM
nivek0 wrote:

can i insert a picture with a if statement
I have 2 pictures but only want to display one dependant on what infomation
is in cell a1 is this possible using a IF statement??

On Monday, June 02, 2008 5:36 PM
Gord Dibben wrote:

Not with a formula.
Not with a formula.

See John McGimpsey's site for a method using a Data Validation dropdown to
select an item which inserts a picture.

http://www.mcgimpsey.com/excel/lookuppics.html


Gord Dibben MS Excel MVP

On Sun, 1 Jun 2008 22:58:00 -0700, nivek05
wrote:

EggHeadCafe - Software Developer Portal of Choice
Forms Auth: Membership, Roles and Profile with no Providers and no Session
http://www.eggheadcafe.com/tutorials...bership-r.aspx

One way (event macro - free) $B!D(B # based on Excel 2003

1. on the Sheet2,
2. Select the cell A1 , Press Alt i p f, and select the picture-1.
3. Adjust the cell A1 size to fit the picture-1.
4. Still selecting the cell A1 condition, press Alt o c w Enter, select B1:D1, Alt e r.
5. Select the cell B1 , Press Alt i p f, and select the picture-2.
6. If needed, adjust the picture-2 size to fit the cell B1.
7. Select the cell C1 , Press Alt i p f, and select the picture-3.
8. If needed, adjust the picture-3 size to fit the cell C1.
9. Select again the cell A1, press Alt i n d, type the name "pic_01", and then click Add OK.
10. Select again the cell B1, press Alt i n d, type the name "pic_02", and then click Add OK.
11. Select again the cell C1, press Alt i n d, type the name "pic_03", and then click Add OK.
12. Select the cell D1, press Alt i n d, type the name "pic_04", and then click Add OK.
13. Select again the cell A1, press Alt e c.
14. move to the Sheet1,
15. Select the cell what you want to display the picture, *hold down Shift key* and press Alt e n.
16. Change the formula "=Sheet2!$A$1" displayed on the formula bar to "=pic_00" and Enter.
17. Press Alt i n d, type the name "pic_00" In the Apply names box,
18. In the "Refers to" box, type or paste following formula
=IF(Sheet1!$A$1=1,pic_01,IF(Sheet1!$A$1=2,pic_02,I F(Sheet1!$A$1=3,pic_03,pic_04)))
and then click Add OK.
19. Now, try to input 1, 2, 3 or others in the cell A1.

HTH
--
MRT


<mahir ibrahim wrote in message ...
Hi,

I have 3 pictures but only want to display one dependant on what infomation
is in cell a1 is this possible using a IF statement??



nivek0 wrote:

can i insert a picture with a if statement
02-Jun-08

I have 2 pictures but only want to display one dependant on what infomation
is in cell a1 is this possible using a IF statement??

Previous Posts In This Thread:

On Monday, June 02, 2008 1:58 AM
nivek0 wrote:

can i insert a picture with a if statement
I have 2 pictures but only want to display one dependant on what infomation
is in cell a1 is this possible using a IF statement??

On Monday, June 02, 2008 5:36 PM
Gord Dibben wrote:

Not with a formula.
Not with a formula.

See John McGimpsey's site for a method using a Data Validation dropdown to
select an item which inserts a picture.

http://www.mcgimpsey.com/excel/lookuppics.html


Gord Dibben MS Excel MVP

On Sun, 1 Jun 2008 22:58:00 -0700, nivek05
wrote:

EggHeadCafe - Software Developer Portal of Choice
Forms Auth: Membership, Roles and Profile with no Providers and no Session
http://www.eggheadcafe.com/tutorials...bership-r.aspx

How can this be done in Excel 2007?



MRT wrote:

One way (event macro - free) $B!
21-Nov-09

One way (event macro - free) $B!D(B # based on Excel 2003

1. on the Sheet2,
2. Select the cell A1 , Press Alt i p f, and select the picture-1.
3. Adjust the cell A1 size to fit the picture-1.
4. Still selecting the cell A1 condition, press Alt o c w Enter, select B1:D1, Alt e r.
5. Select the cell B1 , Press Alt i p f, and select the picture-2.
6. If needed, adjust the picture-2 size to fit the cell B1.
7. Select the cell C1 , Press Alt i p f, and select the picture-3.
8. If needed, adjust the picture-3 size to fit the cell C1.
9. Select again the cell A1, press Alt i n d, type the name "pic_01", and then click Add OK.
10. Select again the cell B1, press Alt i n d, type the name "pic_02", and then click Add OK.
11. Select again the cell C1, press Alt i n d, type the name "pic_03", and then click Add OK.
12. Select the cell D1, press Alt i n d, type the name "pic_04", and then click Add OK.
13. Select again the cell A1, press Alt e c.
14. move to the Sheet1,
15. Select the cell what you want to display the picture, *hold down Shift key* and press Alt e n.
16. Change the formula "=Sheet2!$A$1" displayed on the formula bar to "=pic_00" and Enter.
17. Press Alt i n d, type the name "pic_00" In the Apply names box,
18. In the "Refers to" box, type or paste following formula
=IF(Sheet1!$A$1=1,pic_01,IF(Sheet1!$A$1=2,pic_02,I F(Sheet1!$A$1=3,pic_03,pic_04)))
and then click Add OK.
19. Now, try to input 1, 2, 3 or others in the cell A1.

HTH
--
MRT

Previous Posts In This Thread:

On Monday, June 02, 2008 1:58 AM
nivek0 wrote:

can i insert a picture with a if statement
I have 2 pictures but only want to display one dependant on what infomation
is in cell a1 is this possible using a IF statement??

On Monday, June 02, 2008 5:36 PM
Gord Dibben wrote:

Not with a formula.
Not with a formula.

See John McGimpsey's site for a method using a Data Validation dropdown to
select an item which inserts a picture.

http://www.mcgimpsey.com/excel/lookuppics.html


Gord Dibben MS Excel MVP

On Sun, 1 Jun 2008 22:58:00 -0700, nivek05
wrote:

On Friday, November 20, 2009 5:51 AM
mahir ibrahim wrote:

Insert pictures
Hi,

I have 3 pictures but only want to display one dependant on what infomation
is in cell a1 is this possible using a IF statement??

On Saturday, November 21, 2009 9:49 PM
MRT wrote:

One way (event macro - free) $B!
One way (event macro - free) $B!D(B # based on Excel 2003

1. on the Sheet2,
2. Select the cell A1 , Press Alt i p f, and select the picture-1.
3. Adjust the cell A1 size to fit the picture-1.
4. Still selecting the cell A1 condition, press Alt o c w Enter, select B1:D1, Alt e r.
5. Select the cell B1 , Press Alt i p f, and select the picture-2.
6. If needed, adjust the picture-2 size to fit the cell B1.
7. Select the cell C1 , Press Alt i p f, and select the picture-3.
8. If needed, adjust the picture-3 size to fit the cell C1.
9. Select again the cell A1, press Alt i n d, type the name "pic_01", and then click Add OK.
10. Select again the cell B1, press Alt i n d, type the name "pic_02", and then click Add OK.
11. Select again the cell C1, press Alt i n d, type the name "pic_03", and then click Add OK.
12. Select the cell D1, press Alt i n d, type the name "pic_04", and then click Add OK.
13. Select again the cell A1, press Alt e c.
14. move to the Sheet1,
15. Select the cell what you want to display the picture, *hold down Shift key* and press Alt e n.
16. Change the formula "=Sheet2!$A$1" displayed on the formula bar to "=pic_00" and Enter.
17. Press Alt i n d, type the name "pic_00" In the Apply names box,
18. In the "Refers to" box, type or paste following formula
=IF(Sheet1!$A$1=1,pic_01,IF(Sheet1!$A$1=2,pic_02,I F(Sheet1!$A$1=3,pic_03,pic_04)))
and then click Add OK.
19. Now, try to input 1, 2, 3 or others in the cell A1.

HTH
--
MRT


Submitted via EggHeadCafe - Software Developer Portal of Choice
JQuery and partial views in an ASP.NET MVC application
http://www.eggheadcafe.com/tutorials...ial-views.aspx

Hi Richard,

1. on the Sheet2,
2. Select the cell A1 , insert picture-1.
http://office.microsoft.com/en-us/ex...4091033.aspx#4
3. Adjust the cell A1 size to fit the picture-1.
4. Adjust the cell B1 to D1 size same as the cell A1.
5. Insert the picture-2 & 3 into the cell B1 & C1 in the same way.
6. If needed, adjust the picture-2 & 3 size to fit the cell B1 & C1.
7. Select again the cell A1, define the name as "pic_01".
<http://office.microsoft.com/en-us/ex...8431033#Create a name by using the Create Name dialog
box
8. Select again the cell B1, define the name as "pic_02" in the same way.
9. Select again the cell C1, define the name as "pic_03" in the same way.
10. Select the cell D1, define the name as "pic_04".
11. Select again the cell A1, and copy.
12. move to the Sheet1,
13. Select the cell that you want to display the picture, paste picture as link.
http://office.microsoft.com/en-us/ex...100675631033#2
14. Change the formula "=Sheet2!$A$1" displayed on the formula bar to "=pic_00" and Enter.
15. Define the name as "pic_00" In the Apply names box,
<http://office.microsoft.com/en-us/ex...8431033#Create a name by using the Create Name dialog
box
16. and in the "Refers to" box, type or paste following formula
=IF(Sheet1!$A$1=1,pic_01,IF(Sheet1!$A$1=2,pic_02,I F(Sheet1!$A$1=3,pic_03,pic_04)))
17. Now, try to input 1, 2, 3 or others in the cell A1 in Sheet1.

HTH
--
MRT

<Richard Roberts wrote in message ...

How can this be done in Excel 2007?



MRT wrote:

One way (event macro - free) ... # based on Excel 2003

1. on the Sheet2,
2. Select the cell A1 , Press Alt i p f, and select the picture-1.
3. Adjust the cell A1 size to fit the picture-1.
4. Still selecting the cell A1 condition, press Alt o c w Enter, select B1:D1, Alt e r.
5. Select the cell B1 , Press Alt i p f, and select the picture-2.
6. If needed, adjust the picture-2 size to fit the cell B1.
7. Select the cell C1 , Press Alt i p f, and select the picture-3.
8. If needed, adjust the picture-3 size to fit the cell C1.
9. Select again the cell A1, press Alt i n d, type the name "pic_01", and then click Add OK.
10. Select again the cell B1, press Alt i n d, type the name "pic_02", and then click Add OK.
11. Select again the cell C1, press Alt i n d, type the name "pic_03", and then click Add OK.
12. Select the cell D1, press Alt i n d, type the name "pic_04", and then click Add OK.
13. Select again the cell A1, press Alt e c.
14. move to the Sheet1,
15. Select the cell what you want to display the picture, *hold down Shift key* and press Alt e n.
16. Change the formula "=Sheet2!$A$1" displayed on the formula bar to "=pic_00" and Enter.
17. Press Alt i n d, type the name "pic_00" In the Apply names box,
18. In the "Refers to" box, type or paste following formula
=IF(Sheet1!$A$1=1,pic_01,IF(Sheet1!$A$1=2,pic_02,I F(Sheet1!$A$1=3,pic_03,pic_04)))
and then click Add OK.
19. Now, try to input 1, 2, 3 or others in the cell A1.

HTH
--
MRT

Previous Posts In This Thread:

On Monday, June 02, 2008 1:58 AM
nivek0 wrote:

can i insert a picture with a if statement
I have 2 pictures but only want to display one dependant on what infomation
is in cell a1 is this possible using a IF statement??

On Monday, June 02, 2008 5:36 PM
Gord Dibben wrote:

Not with a formula.
Not with a formula.

See John McGimpsey's site for a method using a Data Validation dropdown to
select an item which inserts a picture.

http://www.mcgimpsey.com/excel/lookuppics.html


Gord Dibben MS Excel MVP

On Sun, 1 Jun 2008 22:58:00 -0700, nivek05
wrote:

On Friday, November 20, 2009 5:51 AM
mahir ibrahim wrote:

Insert pictures
Hi,

I have 3 pictures but only want to display one dependant on what infomation
is in cell a1 is this possible using a IF statement??

Hello MRT,

Thank you for you instructions. Unfortunatley I'm not getting the picture, but a zero instead (so as if the cell was empty). Any advise?

Thanks!

HB



On Tuesday, December 15, 2009 6:33:50 PM UTC+1, MRT wrote:
Hi Richard,1. on the Sheet2, 2. Select the cell A1 , insert picture-1. http://office.microsoft.com/en-us/ex...4091033.aspx#4 3. Adjust the cell A1 size to fit the picture-1. 4. Adjust the cell B1 to D1 size same as the cell A1. 5. Insert the picture-2 & 3 into the cell B1 & C1 in the same way. 6. If needed, adjust the picture-2 & 3 size to fit the cell B1 & C1. 7.. Select again the cell A1, define the name as "pic_01". <http://office.microsoft.com/en-us/ex...8431033#Create a name by using the Create Name dialog box 8. Select again the cell B1, define the name as "pic_02" in the same way. 9. Select again the cell C1, define the name as "pic_03" in the same way. 10. Select the cell D1, define the name as "pic_04". 11. Select again the cell A1, and copy.12. move to the Sheet1, 13. Select the cell that you want to display the picture, paste picture as link. http://office.microsoft.com/en-us/ex...100675631033#2 14. Change the formula "=Sheet2!$A$1" displayed on the formula bar to "=pic_00" and Enter. 15. Define the name as "pic_00" In the Apply names box, <http://office.microsoft.com/en-us/ex...8431033#Create a name by using the Create Name dialog box16. and in the "Refers to" box, type or paste following formula =IF(Sheet1!$A$1=1,pic_01,IF(Sheet1!$A$1=2,pic_02,I F(Sheet1!$A$1=3,pic_03,pic_04))) 17. Now, try to input 1, 2, 3 or others in the cell A1 in Sheet1.HTH -- MRT<Richard Roberts wrote in message ... How can this be done in Excel 2007? MRT wrote: One way (event macro - free) ... # based on Excel 2003 1. on the Sheet2, 2. Select the cell A1 , Press Alt i p f, and select the picture-1. 3. Adjust the cell A1 size to fit the picture-1. 4. Still selecting the cell A1 condition, press Alt o c w Enter, select B1:D1, Alt e r. 5. Select the cell B1 , Press Alt i p f, and select the picture-2. 6. If needed, adjust the picture-2 size to fit the cell B1. 7. Select the cell C1 , Press Alt i p f, and select the picture-3. 8. If needed, adjust the picture-3 size to fit the cell C1. 9. Select again the cell A1, press Alt i n d, type the name "pic_01", and then click Add OK. 10. Select again the cell B1, press Alt i n d, type the name "pic_02", and then click Add OK. 11. Select again the cell C1, press Alt i n d, type the name "pic_03", and then click Add OK. 12. Select the cell D1, press Alt i n d, type the name "pic_04", and then click Add OK. 13. Select again the cell A1, press Alt e c. 14. move to the Sheet1, 15. Select the cell what you want to display the picture, *hold down Shift key* and press Alt e n. 16. Change the formula "=Sheet2!$A$1" displayed on the formula bar to "=pic_00" and Enter. 17. Press Alt i n d, type the name "pic_00" In the Apply names box, 18. In the "Refers to" box, type or paste following formula =IF(Sheet1!$A$1=1,pic_01,IF(Sheet1!$A$1=2,pic_02,I F(Sheet1!$A$1=3,pic_03,pic_04))) and then click Add OK. 19. Now, try to input 1, 2, 3 or others in the cell A1. HTH -- MRT Previous Posts In This Thread: On Monday, June 02, 2008 1:58 AM nivek0 wrote: can i insert a picture with a if statement I have 2 pictures but only want to display one dependant on what infomation is in cell a1 is this possible using a IF statement?? On Monday, June 02, 2008 5:36 PM Gord Dibben wrote: Not with a formula. Not with a formula. See John McGimpsey's site for a method using a Data Validation dropdown to select an item which inserts a picture. http://www.mcgimpsey.com/excel/lookuppics.html Gord Dibben MS Excel MVP On Sun, 1 Jun 2008 22:58:00 -0700, nivek05 wrote: On Friday, November 20, 2009 5:51 AM mahir ibrahim wrote: Insert pictures Hi, I have 3 pictures but only want to display one dependant on what infomation is in cell a1 is this possible using a IF statement??