Help Required With Formula

[microhunt]

I am using the following formula, which works fine. However, I would like to multiply the answer by cell J54
. However when I do this, I am getting a #VALUE! error

=TEXT(F54+H54+I54,"= £#0.00")

=TEXT(F54+H54+I54,"= £#0.00")*J54

Would appreciate any help.

Thanks in advance

 

[microhunt]

I managed to get the formula to work. Senior moment

=TEXT((F54+H54+I54)*J52, "£#0.00")