Pls go through this file and let me know how can you make it simplified.
You can get sum of digits in a cell e.g. if you have 1564 in a cell then the total of 1+5+6+4=16 is automatically shown by the formula.
Invited your suggestions to make it simple :) Cheers :)
can u make it in 2003 format not everybody have ms excel2007
Good one!!
can u make it in 2003 format not everybody have ms excel2007
This is the problem with my formula. It wont work in excel 2003 as i used line of formula's in a single cell which is not compitible for excel 2003.
still i will try to provid the same in excel 2003
Here find attached excel 2003 format. Thanks for your suggestiojns :)
CAclubindia
