hi, I'm not really familiar with Excel (came with my PC) but I thought it
could help me with some minor issues. What I'm trying to do is to make a cell
display a specific number that can change if a value of another cell is
modified.
for example if a cell contains the number "13" the other one should display
"+1" and if the "13" should change to "18" the "+1" should change to "+4", I
tried using the IF function but I'm not familiar with Basic so I couldn't do
what I wanted. The range of numbers I wanted are [2 & 3 = -4, 4 & 5 = -3, 6 &
7 = -2, 8 & 9 = -1, 10 & 11 = 0, 12 & 13 = +1, 14 & 15 = +2, 16 & 17 = +3, 18
& 19 = +4, 20 & 21 = +5, and so on], any help on this matter would be very
much appriciated.