How to show cell results of formula to mix of currency/number formats?

  • Thread starter StargateFanFromWork
  • Start date
S

StargateFanFromWork

I have this formula in cell E3 in a sheet:
=IF($A$2<>"", $E$2 & " x 2 = " & CEILING($E$2*2,0.25),"")

It gives me this result, showing a partiuclar example:
8.4 x 2 = 17

Is there a way to make the above show up in this example formatted as shown
here (currency / number / currency):
$8.40 x 2 = $17.00

I've been working with something simpler in its stead, but it's confusing.
The above "statement" cell result clarifies exactly what is going in the
cell so here's hoping this can be made to work.


****************************
Also, a subsequent formula that depends on a result in E3, in this case here
$17.00, has this result and not a working result:
#VALUE!



Is there a way to have my cake and eat it, too?
I need to have the first formula above with the correct mix of the 2
currency numbers and a regular digit, yet still will allow subsequent
formulas to work?

TIA. :eek:D
 
B

Bob D

Here you are, StargateFanFromWork...

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

StargateFanFromWork

Thank you, that is awesome for the display. I really appreciate you getting
back to me. I still get a #VALUE! in subsequent formulas dependent on that
cell, but the procedure you've outlined here is very good to know and I know
I'll be able to use it in future.

I despaired of finding an answer to this whole issue because of the #VALUE!
So after knocking my head against a wall for a bit <g>, I then realized I
would just have to split the columns. The resultant work was a pain in the
__, but I ended up with the results I absolutely had to have yet all
subsequent formulas work.

So with the example of the "cell" showing:
$8.40 x 2 = $17.00

"$8.40" is now actually in its own cell while " x 2 = $17.00" is adjacent to
it. I removed borders and aligned text so that the two cells look like
they're really one.

Thanks once again! I do a lot of searching through the archives but the
complex stuff like this is just too difficult to figure out without help.

Cheers. :eek:D
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top