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. D

"Charles Chickering" <(E-Mail Removed)> wrote in
message news:8E3EC984-8460-4843-98BD-(E-Mail Removed)...
> =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!
> >
> >
> >
> >