Hi,
I have this formula:
=IF(R80,CONCATENATE("+",R8),R8)
and the results shows me for example: +11.6 but what I really want to
show is +12.
I've been trying to put the "Round" function at a few places in the
formula but it doesn't work.
The closest I got was with this formula:
=ROUND(IF(R80,CONCATENATE("+",R8),R8),0)
where it showed me 12, without the "+" sign before....
Can anyone help me ?
Thanks
--
Outapin
------------------------------------------------------------------------
Outapin's Profile:
http://www.excelforum.com/member.php...o&userid=29278
View this thread:
http://www.excelforum.com/showthread...hreadid=491949