Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers derived from @ right function don't add
Column A Column B Column C
numbers =round(a1,0) =right(B1,1) the numbers in Column C won't add. i keep getting -0- thanks for your help -- aprilshowers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers derived from @ right function don't add
The RIGHT function returns text, which is ignored by the SUM function. Change
formula in column C to: =MOD(B1,10) to return the value of the one's digit. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "april" wrote: Column A Column B Column C numbers =round(a1,0) =right(B1,1) the numbers in Column C won't add. i keep getting -0- thanks for your help -- aprilshowers |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers derived from @ right function don't add
Try changing formula in C1 to: =right(B1,1)+0 this converts text string to number. -- NBVC Where there is a will there are many ways. 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126344 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers derived from @ right function don't add
perfect, both solutions solve the problem. thank you. also i didn't know
that @ right functions return text. -- aprilshowers "april" wrote: Column A Column B Column C numbers =round(a1,0) =right(B1,1) the numbers in Column C won't add. i keep getting -0- thanks for your help -- aprilshowers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight field that are not derived from a formula | Excel Discussion (Misc queries) | |||
Replace a derived value with a label | Excel Discussion (Misc queries) | |||
Vlookup derived wrong value | Excel Worksheet Functions | |||
i need a number total derived from words | Excel Worksheet Functions | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) |