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

This should work:
=IF(R80,CONCATENATE("+",ROUND(R8,0)),R8)

Or you may consider skipping the formula and just formatting R8 with custom
formatting like this:
"+"0;"-"0

"Outapin" wrote:


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

Try this:

=IF(R80,TEXT(R8,"+####"),R8)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Outapin" wrote in
message ...

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