• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formulas

A

Ashok

New Member
Hi,

Please can someone help to correct this, I am using

ROUND(I4*100,0) & "%" & IF(I3<I4,"▲", IF(I3=I4,"●","▼"))

in Cell I, I input a value of 100% in Cell J, I have value of 100%, but when applying this formula, instead of getting "●" in Cell J, I get a down "▼". I have several cells with the same value giving me the same affect.
I have checked my Conditional formatting and seems to be correct as all the other cell show the correct format!

Ashok
 
Hi Ashok,

Given the cell references in your formula try this

=ROUND(I4*100,0)&"%"&IF(I3<I4,"▲",IF(I3=I4,"●",IF(I3>I4,"▼",)))

I'm not sure where "Cell J" comes into it?
 
Oldchippy,
It's worked for that cell, but not for others. I think there is also an error on my conditional formating???
The formula i have used for conditional formating is if Cx>Cx (Blue) and Cx<Cx(Red)
The next input of 99% should show me as down arrow and the colour should be red as it's less than the provious figure.
99%
100%▲
100%●
99%▲
92%▼
88%▼

Ashok
 
i have uploaded the files.
You will see that i have highlighted cells H-I these cells do not perform what i want.

Basicly Cell I11 should be black "." and Cell I12 should be Red with down Arrow because it's lower than the above cell.

if you could highlight where i have gone wrong please.

Many thanks for your help
Ashok
 
Hi oldchippy,

Yes! this will help. Will try it again.

Thanks for you help much appreciated.


BR

Ashok
 
You must log in or register to reply here.
Back
Top