| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
creat the formula
sir how to creat the formula ex. grand total $1245.95 to choose the total =
$1245.00 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
creat the formula
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. -- Max Singapore xde --- "wama" wrote: sir how to creat the formula ex. grand total $1245.95 to choose the total = $1245.00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want to creat custom Number formula | Charts and Charting in Excel | |||
| how to creat a formula to advance date by one year | Excel Worksheet Functions | |||
| Creat Formula for Counting Text | Excel Discussion (Misc queries) | |||
| plz help in to creat formula of excel | Excel Discussion (Misc queries) | |||
| Creat a formula to calculate working hrs according to number of da | Excel Worksheet Functions | |||
Linear Mode
