Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
Formula Text String: Formatting Text and Numbers? | Excel Discussion (Misc queries) | |||
Link to text and return text into a formula? | Excel Worksheet Functions | |||
Excel:Get concatenated text to be recognised as formula not text? | Excel Discussion (Misc queries) | |||
Formula to count text and alert me if a text appears more than twi | Excel Discussion (Misc queries) |