Hi,
I am using bthe formula below to display a dynamic message based on a value in I107. The value is displayed as a %. The rwsult is displayed as a normal number. Is there anyway to fix this to display the number as 63%
The formula
=IF(I107>0.4999,I107 & "% see central support as an issue",J107& "see central support as not being a contributing factor")
The result
0.636363636363636% see central support as an issue
The desired result
63% see central support as an issue
Appreciate your help
Bookmarks