O
Outapin
Hi,
I have this formula:
=IF(R8>0,CONCATENATE("+",R8),R8)
and the results shows me for example: +11.6 but what I really want t
show is +12.
I've been trying to put the "Round" function at a few places in th
formula but it doesn't work.
The closest I got was with this formula:
=ROUND(IF(R8>0,CONCATENATE("+",R8),R8),0)
where it showed me 12, without the "+" sign before....
Can anyone help me ?
Thank
I have this formula:
=IF(R8>0,CONCATENATE("+",R8),R8)
and the results shows me for example: +11.6 but what I really want t
show is +12.
I've been trying to put the "Round" function at a few places in th
formula but it doesn't work.
The closest I got was with this formula:
=ROUND(IF(R8>0,CONCATENATE("+",R8),R8),0)
where it showed me 12, without the "+" sign before....
Can anyone help me ?
Thank