%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

Asmaa Abdulhamid

the shortcut for creating a filter did not work for me

Panagiotis Blatsas

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

Megburu Cynthia

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

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.

Grzegorz

Resolved: Excel practice exam 3 - not clear solution

N P

Practice Exams don't work (Introduction to Excel)