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!

=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!

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" 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!

<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!