<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. :oD

"Charles Chickering" wrote in
message ...
=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.
--
Charles Chickering

"A good example is twice the value of good advice."


"StargateFanFromWork" wrote:

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!