EXCEL公式在帆软无法使用


IF(E3="","",EDATE(E3,12*IF(N3="特殊工种退休",IF(C3="男",55,45),IF(C3="男",60,IF(G3="干部",55,50)))))

请问如何修正才能使用

错误如下:
no function found: EDATE

详细信息

com.fr.stable.InterpreterError: no function found: EDATE at com.fr.parser.FunctionCall.eval(Unknown Source) at com.fr.script.Calculator.eval(Unknown Source) at com.fr.function.IF.evalExpression(Unknown Source) at com.fr.parser.FunctionCall.eval(Unknown Source) at com.fr.script.Calculator.eval(Unknown Source) at com.fr.stable.script.Expression.eval(Unknown Source) at com.fr.script.Calculator.evalString(Unknown Source) at com.fr.script.Calculator.eval(Unknown Source) at com.fr.script.Calculator.evalValue(Unknown Source) at com.fr.stable.AbstractFormulaProvider.evalValue(Unknown Source) at com.fr.report.core.A.J.A(Unknown Source) at com.fr.report.core.A.J.dealWithBENormal(Unknown Source) at com.fr.report.core.A.m.cc_ce_array(Unknown Source) at com.fr.report.core.A.J.A(Unknown Source) at com.fr.report.core.A.J.A(Unknown Source) at com.fr.report.core.A.J.A(Unknown Source) at com.fr.report.core.A.J.A(Unknown Source) at com.fr.report.core.A.J.A(Unknown Source) at com.fr.report.core.A.J.C(Unknown Source) at com.fr.report.core.A.J.execute4Expand(Unknown Source) at com.fr.report.core.sheet.SheetSequenceExecutor.execute4Expand(Unknown Source) at com.fr.report.core.sheet.SequenceExecutor.execute(Unknown Source) at com.fr.report.core.sheet.SheetSequenceExecutor._execute(Unknown Source) at com.fr.report.core.sheet.SheetSequenceExecutor.execute(Unknown Source) at com.fr.stable.AbstractActor.executeWorkBook(Unknown Source) at com.fr.stable.AbstractActor.executeWorkBook(Unknown Source) at com.fr.main.impl.WorkBook.execute(Unknown Source) at com.fr.log.LogUtils.executeAndLogRecord(Unknown Source) at com.fr.stable.AbstractActor.getResultBookFromCacheIfNeed(Unknown Source) at com.fr.main.impl.WorkBookTemplateDelegate.execute(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.calResultWorkBook(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.initBook2Show(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.getWorkBook2Show(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.getReport2Show(Unknown Source) at com.fr.web.data.CalculatableAction.readContent(Unknown Source) at com.fr.web.core.A.zA.actionCMD(Unknown Source) at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(Unknown Source) at com.fr.web.core.WebActionsDispatcher.dealForActionDefaultCmd(Unknown Source) at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(Unknown Source) at com.fr.web.core.A.xC.process(Unknown Source) at com.fr.web.core.ReportDispatcher.dealWithOp(Unknown Source) at com.fr.web.core.ReportDispatcher.dealWeblet(Unknown Source) at com.fr.web.core.ReportDispatcher.dealWithRequest(Unknown Source) at com.fr.web.BaseServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:635) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)

FineReport博哥 发布于 2018-8-14 14:37
悬赏:2 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共5回答
最佳回答
0
flyingsnake发布于2018-8-14 14:37(编辑于 2023-9-6 09:34)
555
最佳回答
0
白水先生发布于2018-8-14 14:40(编辑于 2023-9-6 09:34)
555
最佳回答
0
博哥发布于2018-8-14 14:42(编辑于 2023-9-6 09:34)
555
最佳回答
0
白水先生发布于2018-8-14 14:48(编辑于 2023-9-6 09:34)
555
最佳回答
0
flyingsnake发布于2018-8-14 14:54(编辑于 2023-9-6 09:34)
555
  • 0关注人数
  • 1335浏览人数
  • 最后回答于:2018-8-14 15:03
    活动推荐 更多
    热门课程 更多
    返回顶部