If statement arrow

[#1]

hi,

I'm trying to write a statement that says =if(sum(Budget) > sum(Actual), 'qmem://Arrow/GreenUp',if(sum(Budget)<sum(Actual),'qmem://Arrow/RedDown'). It is not working and I'm not sure what is wrong with the syntax. Does anyone know?

Thank you!

[kumarnatarajan]

Hi ,

I think your syntex is right check your compared values.

Else

Try this

EX: =if(sum(Budget) > sum(Actual),'qmem://Arrow/GreenUp','qmem://Arrow/RedDown')

[#3]

This does not work. I get a text box with the formula in it. Any other ideas would be very helpful!

[kumarnatarajan]

Hi,

I think your load qmem file error so check the below syntex.

Ex: if(sum(Budget) > sum(Actual),'Yes','No')

[#5]

But that would not get me to an up or a down arrow as the output, correct? How would I address the qmem file error?

[rustyfishbones]

Hi

I think the following will work better

if(sum(Budget) > sum(Actual),'qmem://<bundled>/BuiltIn/arrow_s_r.png','qmem://<bundled>/BuiltIn/arrow_n_g.png'))

and make sure the representation is Image

[er_mohit]

Try this:

=RangeOnly(if(GetCurrentSelections() & Budget > Actual, 'qmem://Arrow/GreenUp','qmem://Arrow/RedDown')).

[#8]

this works in that I get a green arrow but I want the arrow that looks like just a triangle (without a stem).. is there a way to use this code to get that kind of arrow? Thanks! (and sorry for being picky...)

[#9]

This gives me a "-" ... no arrow for now!

[rustyfishbones]

Try this video I created on YouTube.

Have you used Character Map before?

check this out

http://youtu.be/RdDFHhNAOKI