You could create a table that looks like

2 -4
4 -3
6 -2
8 -1
10 0
12 +1
14 +2
16 +3
18 +4
20 +5

call it MyTable (select it band do insertnamedefine and type the name or
type it in the namebox)
then use a formula like

=IF(A1<2,"",VLOOKUP(A1,MyTable,2))

or hardcoded


=IF(A1<2,"",VLOOKUP(A1,{2,"-4";4,"-3";6,"-2";8,"-1";10,"0";12,"1";14,"+2";16,"+3";18,"+4";20,"+5"}, 2))

note tyhat I am using text representations of the numbers -4 - +5
you could use numeric values and use a custom format like

+General;-General;0

--
Regards,

Peo Sjoblom


"hakkabuff" wrote in message
...
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.