Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add cell "50+55+50+50" to give answer 205
I have a cell where I need to keep the amounts separate to show workings
out, but I need this to be then added up in a sum, is there a way to do this as at present I have to manual work this out and enter in another cell toget the answer and this leaves too much room for error. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"" does not seem to give a Blank cell | Excel Discussion (Misc queries) | |||
OK. I give. Why can't I use the "@" (at sign) in a text cell? | Excel Discussion (Misc queries) | |||
I want to place a "x" in a cell and give it a value of 1 (Excel) | Excel Worksheet Functions | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |