Hi I have the following question that I am struggling with solving
I have si numbers from a lotto draw to which firstly I would like to subtract each number by 25 and record into cells , therafter if the result is a negative number I would like to add a formula to add 49 to the negative number to get to a positive number ex 6 27 15 26 33 7 6-25= -19 this wil be added to cell h2 this negative number should be added to cell l2 after adding 49 if the number is negative.
b2=6 c2=27 d2=15 e2=26 f2=33 g2 =7 h2 = -19( 6-25) i2 =2 (27-25) etc n2 = h2 if negative 49 to be added to make it a positive number ... s2
I will greatly appreciate help with a formula please for excel also if value in the first is 25 so 25-25 = 0 if zero 49 to be added
Thank you in anticipation for all the help received