Forum Discussion
Saurav_Kaura
Oct 30, 2021Copper Contributor
'Else part' of if() is executed even if the condition mentioned is true.
Here i'm using if function to get value of age column. formula used is: if (f2<100,100-f2+14,f2-14) I am always getting answer from f2 -14 but the answer should come from 100-f2+14 Please help. H...
OliverScheurich
Oct 30, 2021Gold Contributor
Column F is formatted as text. Enter this formula in F2 and copy down:
=NUMBERVALUE(MID(A2,3,2))