How to add text to this formula?
 

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!

How to add text to this formula?
 

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

How to add text to this formula?
 

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!

How to add text to this formula?
 

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