Hi all,
Below I show the formula in each cell and then the 'output' in bold
A1 : Input cell: 1 : 6
A2 : =TRIM(LEFT(A1, SEARCH(":",A1,1)-1)) : 1
A3 : =TRIM(RIGHT(A1,LEN(A1)-SEARCH(":",A1,SEARCH(":",A1)-1))) : 6
A4 : =(A3*2) : 12
A5 : =IF(A2>A4,"G","R") : G
Currently, for some reason the final cell is showing G
This is wrong, clearly A2 (1) is not greater than A4 (12)
However, if I replace the formula in A2 by just typing the number "1", cell A5 will change to correctly displaying "R"
What is it that is wrong with cell A2 that means that whilst displaying "1" correctly, when using that "1" in a further calculation an error occurs.
Thanks
Bookmarks