

 Thread Tools  Search this Thread 
#1
 
 
How to use vlookup for rounding up numbers in Excel 2003 I'm using Excel 2003 on my system. I would like to know that how can i use vlookup for rounding up a particular number in my excel sheet. It should be round up to its nearest number. Can any body tell me that how can i do it? Does any body have any idea about it? Kindly provide me the correct sloution for the above issue. Any kind of information on the above issue would be appreciated. 
#2
 
 
Re: How to use vlookup for rounding up numbers in Excel 2003 In Excel you can easily round number in order to view it. You can do it by just going to FormatMenu and then select Cells Numberand then need to select Number under Category. Then you can create a short cut by using the Increase Decimals and Decrease Decimals on the Format toolbar, which you can see it at the right of $ %, symbols. 
#3
 
 
Re: How to use vlookup for rounding up numbers in Excel 2003 You can also use the following: The HLOOKUP function uses the following syntax: Quote:
Quote:

#4
 
 
Re: How to use vlookup for rounding up numbers in Excel 2003 Use the TRUNC function in your VLOOKUP or HLOOKUP function to force the LOOKUP value to be evaluated to a specific number of decimal places. For example, type the VLOOKUP function as follows: Quote:


Tags: excel 2003, rounding up, vlookup 
Thread Tools  Search this Thread 

Similar Threads for: "How to use vlookup for rounding up numbers in Excel 2003"  
Thread  Thread Starter  Forum  Replies  Last Post 
Need help to get rid of #n/a error in Excel Vlookup  Culpritism  MS Office Support  2  24022012 07:39 PM 
How to make Microsoft Excel to stop rounding out 16 digit number  Talisha  MS Office Support  2  01022012 07:10 PM 
How to get yes or no in Vlookup in Excel  Gurmeet  MS Office Support  2  24012012 04:57 PM 
How to change negative numbers to positive numbers in Excel  Shaina Na  Microsoft Project  3  08012012 05:35 PM 
How to convert fractional inches into rounding numbers  Rock Villa  Software Development  2  01072009 12:54 PM 