请帮忙将Excel中的vb语句转换成vfp语句,谢谢!
我从一个Excel文档中看到的单元格的计算公式,但我无力转化成vfp语句,请各位大侠帮忙,谢谢!这是一个新高考等级赋分的计算方法,原单元格的计算公式为:
=IF(D3="","",MAX(IF(AND(D3<=LARGE(D:D,1),D3>=LARGE(D:D,COUNT(D:D)*0.15)),ROUND(86+(14/(LARGE(D:D,1)-LARGE(D:D,COUNT(D:D)*0.15)))*(D3-LARGE(D:D,COUNT(D:D)*0.15)),0),0),IF(AND(D3<LARGE(D:D,COUNT(D:D)*0.15),D3>=LARGE(D:D,COUNT(D:D)*0.5)),ROUND(71+(14/(LARGE(D:D,COUNT(D:D)*0.15)-1-LARGE(D:D,COUNT(D:D)*0.5)))*(D3-LARGE(D:D,COUNT(D:D)*0.5)),0),0),IF(AND(D3<LARGE(D:D,COUNT(D:D)*0.5),D3>=LARGE(D:D,COUNT(D:D)*0.85)),ROUND(56+(14/(LARGE(D:D,COUNT(D:D)*0.5)-1-LARGE(D:D,COUNT(D:D)*0.85)))*(D3-LARGE(D:D,COUNT(D:D)*0.85)),0),0),IF(AND(D3<LARGE(D:D,COUNT(D:D)*0.85),D3>=LARGE(D:D,COUNT(D:D)*0.98)),ROUND(41+(14/(LARGE(D:D,COUNT(D:D)*0.85)-1-LARGE(D:D,COUNT(D:D)*0.98)))*(D3-LARGE(D:D,COUNT(D:D)*0.98)),0),0),IF(AND(D3<LARGE(D:D,COUNT(D:D)*0.98),D3>=LARGE(D:D,COUNT(D:D)*1)),ROUND(30+(10/(LARGE(D:D,COUNT(D:D)*0.98)-1-LARGE(D:D,COUNT(D:D)*1)))*(D3-LARGE(D:D,COUNT(D:D)*1)),0),0)))