%var formula does not work for me

in Introduction to Excel / Calculating Growth Rates in Excel

Copied the formula from the PDF, ensured the cells are correct and I'm just getting an error. Formula I'm using is...

=IF(ISERROR((D4/C4)-1);"n.a.";IF(((D4/C4)-1)>1;">100.0%";IF(((D4/C4)-1)<-1;"<-100.0%";((D4/C4)-1))))

This returns "There's a problem with this formula"

0 answers ( 0 marked as helpful)

Submit an answer

related questions

Megburu Cynthia

The f5 doesn't work. what other options can be used?

Panagiotis Blatsas

Index and Match exercise tried the exact formula yet all results are N/A?

Asmaa Abdulhamid

the shortcut for creating a filter did not work for me

Nessma

After finished this course, will i get a certificate or not?

Saber Ahmad

The feature is not working

Esqin Kazimov

Resolved: I face with "File not found!" error.

Frank Kustin

Practice Exam 1 asked questions on material not covered

Jahnavi Patel

Course not moving forward.

N P

Practice Exams don't work (Introduction to Excel)

Grzegorz

Resolved: Excel practice exam 3 - not clear solution

Asmaa Abdulhamid

what does the number of hash symbols mean??

Ahmed r. j. Hassan

hi..i did not understand from the minute 1:4 to the end ...