|
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?? |
can i insert a picture with 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?? |
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?? 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 |
Insert pictures
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 |
Excel 2007
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 |
Excel 2007
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?? |
Excel 2007
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?? |
| All times are GMT +1. The time now is 05:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com