主题：多种计法请教

试试看
1、Right(text(15-number(cell(row-1,"智能数"))))；
2、Right(text(19-number(cell(row-1,"智能数"))))；
3、Right(text(21-number(cell(row-1,"智能数"))))；
4、Right(Text(Number(Left(Cell(Row-2,"智能数")))+Number(Right(Cell(Row-1,"智能数")))))；
5、Right(Text(Number(Right(Cell(Row-2,"智能数")))+Number(Left(Cell(Row-1,"智能数")))))；
6、Right(Text(Number(Right(Cell(Row-2,"智能数")))+Number(Right(Cell(Row-1,"智能数")))))；
7、If(Row < 4,"",Right(Text(Number(Right(Cell(Row-1,"智能数")))+Number(Right(Cell(Row-3,"智能数"))))))；
8、Right(text(2 * number(cell(row-1,"智能数"))))；
9、Right(text(4 * number(cell(row-1,"智能数"))))；
10、If(number(cell(row-1,"智能数")) < 14,right(text(number(cell(row-1,"智能数"))+7)),right(text(number(cell(row-1,"智能数"))-7)))；
11、Right(text(number(cell(row-1,"智能数"))+2))；
12、Right(text(number(cell(row-1,"智能数"))+6))

-=-=-=- 以下内容由 wjq1072 在 2009年06月17日 08:53pm 时添加 -=-=-=-
公式大同小异啊