How to add text to this formula?

[StargateFanFromWork]

How can I add this cell value and this text "$E$2 x 2 =" to the formula:
=IF($A$2<>"",CEILING(($E$2*2),0.25),"")

I'm guessing that it might something along this line (?):
=IF($A$2<>"",($E$2) & " x 2 = " & (CEILING(($E$2*2)),0.25),"")
though this doesn't work.

I've tried everything I know, which admittedly isn't much, trying to get
this to work but nothing I've tried works. Hopefully this can be done,
though.

Thanks!

 

[Charles Chickering]

=IF($A$2<>"", $E$2 & " x 2 = " & CEILING($E$2*2,0.25),"")

works for me, I don't like having all the extra paranthesis as it is very
confusing to read.

 

[RST]

It looks like you just have some parenthases in the wrong place...try this:

=IF($A$2<>"",($E$2) & " x 2 = " & (CEILING(($E$2*2),0.25)),"")

RST

 

[StargateFanFromWork]

<lol> I guess that's why it didn't work; I had to many brackets in there
.... I was just trying to outline the formula. Scary how close it came. <g>

Well, this does work, you're right, but I ran into some trouble.
Instead of getting-
$8.40 x 2 = $17.00,

I get-
8.4 x 2 = 17

Is there a way to show the currency as currency?

Also, underneath that cell, in E4, I don't get a result I get #VALUE!

Are these 2 problems fixable?

Tx. D