Help with formating 0.00

[Teppid]

Hi,

I have this formula;

=IF(ISTEXT($F$11),TEXT(ROUNDDOWN(E19/$H$11,0),"0")&" free month(s) of "&$F$11&" plus £"&E19-ROUNDDOWN(E19/$H$11,0)*$H$11,"""")

the output of this should be "8 free month(s) of HEC plus £1.20"

What I am getting is "8 free month(s) of HEC plus £1.2"

the cell format is General but even if I change it I cannot get the 2 decimal places !

Help please

Tepp

[ChemistB]

replace

E19-ROUNDDOWN(E19/$H$11,0)

with
TEXT(E19-ROUNDDOWN(E19/$H$11,0),"#.##")

Does that work for you?

[Teppid]

Comes up with 155.1 :-(

has changes the sum. this is driving me insane lol

[DonkeyOte]

perhaps change:

E19-ROUNDDOWN(E19/$H$11,0)*$H$11

to

TEXT(E19-ROUNDDOWN(E19/$H$11,0)*$H$11,"0.00")

[ChemistB]

Okay, into the cell where you are getting 8 free month(s) of HEC plus £1.2
paste this formula

=IF(ISTEXT($F$11),TEXT(ROUNDDOWN(E19/$H$11,0),"0")&" free month(s) of "&$F$11&" plus £"&TEXT((E19-ROUNDDOWN(E19/$H$11,0)*$H$11),"0.00"),"""")

Does that work?

[Teppid]

Thank you loads guys, I tried Donkeyote's solution and it worked great.

Thank you both for your time with this.

Tepp