Hi Guys, i am using the following formula in cell F5:F7
=IF(E7>0,CONCATENATE(FIXED(E7*100,2,TRUE),"%",REPT(“”,10-LEN(FIXED(E7*100,2,TRUE))),”▲”),IF(E7<0, CONCATENATE(FIXED(E7*100.2,TRUE),"%",REPT("",10-LEN(FIXED(E7*100,2,TRUE)))," ▼"),CONCATENATE(FIXED(E7*100,2,TRUE),"%",REPT(" ",9-LEN(FIXED(E7*100,2, TRUE))),"◄►")))
It works in F7 but not F5 or F6 and is resulting in #name? error... and im not sure why this could be! any suggestions would be appreciated!
I have attached the workbook if that helps.
Many thanks
Bookmarks