Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am new to Q and i am trying to convert formula in excel to Q. Appreciate your help
=IF(+MAX(+IFERROR(MAX(1-ABS(O61-N61)/O61,0),1),0)>1,0,+MAX(+IFERROR(MAX(1-ABS(O61-N61)/O61,0),1),0))
Maybe this:
=IF(RANGEMAX(ALT(RANGEMAX(1-FABS(O61-N61)/O61,0),1),0)>1,0,RANGEMAX(ALT(RANGEMAX(1-FABS(O61-N61)/O61,0),1),0))