IF Function

[dad0519]

I need to create a sheet that creates the results listed below.
If I put a 1 in cell A1 the result would be 1. If I put a 1.5 in cell A1 the result would be 2. If I put a 2 in cell A1 the result would be 3. If I put a 2.5 in cell A1 the result would be 4. If I put a 3 in cell A1 the result would be 5.

[Zizi64]

You can use formula:
y = 2x - 1

Code: Select all

=2*A1-1

or you can use the function VLOOKUP() based on the two column

Code: Select all

   E    F
1  1    1
2  1.5  2
3  2    3
4  2.5  4
5  3    5

Code: Select all

=Vlookup(A1;E1:F5;2)