The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Getting Error with Calculating Growth Rates with predefined Universal Formula

Getting Error with Calculating Growth Rates with predefined Universal Formula

0
Votes
1
Answer

Hi Team,
I’m trying to work out the %es for Growth rates within Excel course and found in the video module where the Universal formula is applied, I’m getting error despite it being correct.
Here is the formula as shown in the respective class that I ‘m trying to apply but getting error – I”m unable to attach the error here as I don’t find how to attach the image from local desktop in this query.
=IF(ISERROR((D4/C4)-1);”n.a.”;IF(((D4/C4)-1)>1;”>100.0%”;IF(((D4/C4)-1)<-1;”<-100.0%”;((D4/C4)-1))))
Error: “There is a problem with this formula” and then  it goes onto say If I were not trying to type in a formula…..

1 Answer

365 Team
0
Votes

Hi!
Please make sure you are using the correct argument separator.
In this case, it is semicolon (;) but for your PC it may be comma (,)
Best,
Ned

×
LAST CHANCE
Ready to Learn Data Science?
50% OFF