Skip to content

ACCA Forums

FMF9 CBE equations not working in excel, Miller-Orr

AAnna-marie8y ago
Hi, I hope someone can help me. I have tried doing the Miller-Orr equation in excel many different ways but I cannot get the right answer, when I do it on my calculator it is correct but it's hard to show workings in excel that you have done on the calculator. I am typing into excel =POWER(3*((3/4*18*1000000)/0.00014),1/3) and it is coming up with 6613.67 I am typing it into my calculator 3*((3/4*18*1000000)/0.00014) to the power of function button 1/3 and it is coming up with the correct answer 13756.98 What am I not understanding here? Thanks :)
Sign into reply to this topic.