Good Day
I have a sheet where I add all the values in Column N and add it up in column P
I then have logic to put the value where it is bigger than 45 in column D in the last row. I then need to match that value to one of the values in Column N and then put the value of Yes in column G
All this works 100% where column N doesn't have decimal values. The problem is when there are decimal values in column N, column P and column D disregards (Rounds) this and then I don't find a match between column D and column N
Example: The total for column N = 46,5. Thus it is 1,50 > 45. The problem is the value of 2 gets written to column D and not 1,50 and column P is also incorrect as it is rounding the values as column P = current row + previous row of column N. Column P total must be 46,50 and not 47,00 There should be a Yes in column G in row 2 as the value of 1,50 is there
I have tried making column D and column P of type Number with 2 decimals and I have also tried the Round function (with 2 decimals) in VBA but it doesn't work. How can I fix this? Column N works perfectly
I have a sheet where I add all the values in Column N and add it up in column P
I then have logic to put the value where it is bigger than 45 in column D in the last row. I then need to match that value to one of the values in Column N and then put the value of Yes in column G
All this works 100% where column N doesn't have decimal values. The problem is when there are decimal values in column N, column P and column D disregards (Rounds) this and then I don't find a match between column D and column N
Example: The total for column N = 46,5. Thus it is 1,50 > 45. The problem is the value of 2 gets written to column D and not 1,50 and column P is also incorrect as it is rounding the values as column P = current row + previous row of column N. Column P total must be 46,50 and not 47,00 There should be a Yes in column G in row 2 as the value of 1,50 is there
I have tried making column D and column P of type Number with 2 decimals and I have also tried the Round function (with 2 decimals) in VBA but it doesn't work. How can I fix this? Column N works perfectly