Novice_user
New Member
- Joined
- Nov 29, 2016
- Messages
- 9
Hi All,
I am very new to excel so bear with me please...!
So, I have a set of numbers in two columns
<tbody>
</tbody>
In column D I want to produce the following results - if the numbers in column C are greater than B then display the number in C, otherwise display column B
I tried using the IF formula =IF(c1>b1,c1,b1)
which was great & worked but when it got to name g the result returned was 8/2 which isn't right.
I looked further down and the results remain inconsistent throughout.
Help please!!
I am very new to excel so bear with me please...!
So, I have a set of numbers in two columns
A | B | C | |
1 | a | 13/3 | 14/9 |
2 | b | 15/6 | 16/3 |
3 | c | 10/3 | 12/3 |
4 | d | 14/6 | 14/9 |
5 | e | 8/10 | 6/5 |
6 | f | 10/11 | 12/3 |
7 | g | 12/0 | 8/2 |
8 | h | 12/9 | 14/0 |
9 | i | 9/7 | 10/7 |
<tbody>
</tbody>
In column D I want to produce the following results - if the numbers in column C are greater than B then display the number in C, otherwise display column B
I tried using the IF formula =IF(c1>b1,c1,b1)
which was great & worked but when it got to name g the result returned was 8/2 which isn't right.
I looked further down and the results remain inconsistent throughout.
Help please!!