如何将这些Excel函数正确转换为C程序中的函数? [英] How Do I Convert These Excel Functions Correctly Into Functions In A C Program?
问题描述
我有这个excel文件(代表MM1队列模拟)
i很难弄清楚什么是错的,因为每个部分都能很好地运行标记错误的地方
我正在使用花车,正确地完成了3/4的程序,除了几个零件
这些excel函数,我遇到问题
i创建了一个函数来返回最多2个浮点数,另一个函数来计算数组中超过一定值的单元格
但是结果不对,它总是没有改变0 1 1之后1 1 2
函数excel = MAX(J5-(COUNTIF($ I $ 5:$ I $ 34,> =&C5) - COUNTIF($ I $ 5:$ I $ 34,> =&C6)),0)
#in QueueBefore = bfinq
函数excel = IF(((COUNTIF($ I $ 5:$ I $ 34,> =&C5) - COUNTIF($ I $ 5:$ I $ 34,> =&C6))= L5),0,1)
#在ServerBefore = bfins
取决于前2名所以它不起作用
#在Que中ueAfter = afinq
i have this excel file (represents the MM1 queue simulation)
i have a hard time figuring out what's wrong because each part works well on its own i've marked the places that are wrong
i'm working with floats ,and done 3/4 of the program correctly except for few parts
these excel functions that i'm having problems with
i created a function to return max of 2 floats and another to count the cells in an array that are more than a certain value
but the result is not right it isn't changing always 0 1 1 after 1 1 2
function in excel =MAX(J5-(COUNTIF($I$5:$I$34,">="&C5) - COUNTIF($I$5:$I$34,">="&C6)),0)
# in QueueBefore=bfinq
function in excel =IF(((COUNTIF($I$5:$I$34,">="&C5) - COUNTIF($I$5:$I$34,">="&C6))=L5), 0,1)
# in ServerBefore=bfins
depends on the top 2 so it isn't working
# in QueueAfter =afinq
推荐答案
我
5:
我
这篇关于如何将这些Excel函数正确转换为C程序中的函数?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!