Hi all,
I am trying to create a cell that will express the difference between two numbers as a percentage.
The problem is trying to add a "+" sign to the number if it is positive.
I have tried to use if(A1>0,"+"&A1,A1) but then I get something like +0.564586218431
I then tried something like if(A1>0,"+"&round(A1,3),A1) and I get +0.565 (even though the format is in percentage)
I tried a lot of other things including custom formats but have run out of ideas.
Does anyone want to give this a shot?
Bookmarks