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.
IF Function
IF Function
Apache Openoffice 4.1.1
AOO411m6(Build:9775) - Rev. 1617669
2014-08-13 09:06:54 (Mi, 13 Aug 2014)
AOO411m6(Build:9775) - Rev. 1617669
2014-08-13 09:06:54 (Mi, 13 Aug 2014)
Re: IF Function
You can use formula:
y = 2x - 1
or you can use the function VLOOKUP() based on the two column
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)
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.