| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can set how a number rounds up in excel
I have the folling formula =IF(B2<=0," ",IF(B20,B2*1.5%)) I want excel to
round up the results if there are more than 2 digits after the decimal point example 8.011 becomes 8.01 what do I need to add to this formula to do that? |
|
#2
|
|||
|
|||
|
Please see other post. Please try not to multi post the same question. But I replied to other post with: Try the following =IF(B3<=0," ",IF(B30,(ROUNDUP((D2+B3)*1.5%,2)))) Celtic_Avenger -- Celtic_Avenger ------------------------------------------------------------------------ Celtic_Avenger's Profile: http://www.excelforum.com/member.php...o&userid=14101 View this thread: http://www.excelforum.com/showthread...hreadid=273026 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| how do i set up excel to copy from one cell to a given number of . | Excel Discussion (Misc queries) | |||
| how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel | |||
Linear Mode
