convert a negative number to a positive number by adding 49

Hi

I need some help with a formula to do some calculations for me


I have a set of six numbers that are recorded in a worksheet that I am attching

I would like each number to be subtracted by 25

The next I would like to take the value and if its a negative one to add 49 to it

Iff the first number after subtracting is 0 , 49 should be added to it


Thank you in anticipation

Raj

Hi

Thank you for your help so kind of you.

I think I have not really made my self very clear.

I have a set of 6 numbers from a lotto results.
To each of these numbers I need to subtract 25 and get a value. The result will be positive or negative .

If the value is 0 after subtraction , 49 should replace the zero

So I will in turn now get 6 new sets of numbers in the the row.

my third row should look at each number in the second set and if the value is a negative one example -19, 49 must be added to this number to get a positive value.

so if my first set is 6 25 3 45 27 13 after subtracting 25 will be -19 0 -22 20 2 -12 the sero must be replaced by 40
the third set if the number is negative 49 must be added to it -19+49 = 30 49 27 (-22+49) 20 2 37(-12+49)

I trust that this may help with solving my issue

Thanking you in anticipation

Raj
49

Third set

=IF(B3<=25,B3+24,B3-25)

as per Special-K

OR

=IF(I3<=0,I3+49,I3)

Hi

Thank you Special-K John Topley and boonpathiraja for the help

Its working brilliantly