Insert a figure waf. IF statement

M

mowen

Hi
I wonder if it is some possibility to insert a figure/clip art o
picture with the aid of a IF statement?
I use Excel 2003.

example
If the person is higher at the list this time then last, insert i gree
arrow...

best regards
Run
 
F

Frank Kabel

Hi
only possible with VBA. If you're happy with a hyperlink this could be
achieved with IF and HYPERLINK
 
M

mowen

Hi Frank

I'm not so familiar with VBA programming so I need help to do thi
work. Could you be so kind and help me?

best regards
Run
 
F

Frank Kabel

Hi
sure but you first may provide some more details what you're trying to
do. e.g. your conditions, where are the files stored, etc.
 
M

mowen

Hi
I will try to explain the whole problem. I have a competition going o
and have a table like this.

Name A 23
Name B 12
Name C 24
Name B 23
 
M

mowen

Frank

I don't understand what you mean? You can't see the whole messages
wrote or... do you need more explanation?

Run
 
F

Frank Kabel

Hi
yes: What is your expected result for example. I think if you only need
an arrow this could be achieved with formulas
 
M

mowen

Hi again

My intention is to show the participant the change in places from las
update, are they going up or down. The points will increase for ever
new round.

round 1
Name A 23 points
Name B 21 points

round 2
Name B 47 points up arrow
Name A 45 points down arrow
and so on..

Run
 
M

mowen

Hi Frank
I want to take up this tread again and under I have paste in my las
replay.

My intention is to show the participant the change in places from las
update, are they going up or down. The points will increase for ever
new round.

round 1
Name A 23 points
Name B 21 points

round 2
Name B 47 points up arrow
Name A 45 points down arrow
and so on..

Run
 
Top