Concatenate to show values to 2 decimal points

[VBA learner ITG]

Hi all,

I have tried Google to find a fix to my issue but nothing has worked.

The problem that I have is the below formula needs to show 2 decimal points when it concatenates.

=IFERROR(IF($CJ2=$CK2,$CJ2,IF(CZ2=2,(CONCATENATE("£",$CJ2," / ","£",$CK2)),IF(CZ2>2,(CONCATENATE("£",$CJ2," - ","£",$CK2)))))," ")

Example of how the output is currently shown

£2 / £4

The desired result

£2.00 / £4.00

Any help would be appreicated.

 

[jasonb75]

Try

=IF($CJ2=$CK2,$CJ2,TEXT($CJ2,"£0.00")&IF(CZ2=2," / "," - ")&TEXT($CK2,"£0.00"))

There is nothing in the formula to cause an error so IFERROR should not be needed.

 

[Fluff]

If you want the cell "blank" if CZ2 <2 then try
=IF($CJ2=$CK2,$CJ2,IF($CZ2<2,"",TEXT($CJ2,"£0.00")&IF(CZ2=2," / "," - ")&TEXT($CK2,"£0.00")))

 

[VBA learner ITG]

Thank you so much for your replies and formula.
It worked as needed.

I cannot thank you enough for your help.

 

[Fluff]

Glad we could help & thanks for the feedback.