W wama Dec 7, 2009 #1 sir how to creat the formula ex. grand total $1245.95 to choose the total = $1245.00
M Max Dec 7, 2009 #2 If you have for example in A2: 1245.95, then: =INT(A2) will give you 1245. INT will round a number down to the nearest integer. You could use INT(A2) as the lookup value to match in index/match or in vlookup. Any good? hit the YES below.
If you have for example in A2: 1245.95, then: =INT(A2) will give you 1245. INT will round a number down to the nearest integer. You could use INT(A2) as the lookup value to match in index/match or in vlookup. Any good? hit the YES below.
