View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
StargateFanFromWork[_4_] StargateFanFromWork[_4_] is offline
external usenet poster
 
Posts: 51
Default 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!