Question please. Would like to ask if it is possible to have two formatting in one line item? for example (see ss below), the columns are line items and the rows are LIS. The GLA for 2018A and 2019B (9% & -3%) are percentage change variance while the Lease out rate formula is the difference of 2018A and 2019B (4p%ts & 1%pts). Thank you.
However, if it is really a must have, you can format the line item to text and then use the TEXT formula to convert the number into text and concatenate the % symbol. Something like: IF Opstats = 2018A THEN TEXT(Number line item) & "%" ELSE TEXT(Number line item)
Keep in mind that the TEXT formula can cause some artifacts when converting from number and test thoroughly