Forum Discussion
Calculating the "spread" between multiple numbers in one cell.
Is there a way to calculate the difference between multiple numbers in one cell that are separated by a forward slash? This is for a spreadsheet that I'm using to track stock option trades. The cell ...
As variant
=LET(a, TEXTSPLIT(A2, "/"), MAX( ABS( TOROW(CHOOSECOLS(a - DROP(a,,1), {1,3}),2) ) ) )