TransWikia.com

IF function calculates result correctly, then evaluates to #N/A

Super User Asked by aqua on December 19, 2020

I have the following function:
=IF($C3="I_sc",CORREL(INDIRECT(J2&ROW($C4)&":"&J2&ROW()+MATCH("I_sc",INDIRECT("c"&ROW($C4)&":c2300"),0)),INDIRECT(J1&ROW($C4)&":"&J1&ROW()+MATCH("I_sc",INDIRECT("c"&ROW($C4)&":c"&"2300"),0))),"")

It gives #N/A as a result. However, when I go through it step-by-step with the ‘Evaluate formula’, at the last step it gives:
enter image description here

Then:
enter image description here

What could go wrong here?

Thank you!

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP