| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ROUND the result of a formula
I have the following formula and need the result to round to two decimal
points: =IF(ISBLANK(B12),"",IF(AND(D12=IFIS!$C$2,$F$3<"G B"),$D$5*1.056,$D$5)) Currently the result is displaying rounded down to two decimal points but I need the actual value to be two decimal points since it is used for other calculations. Thanks for any assistance. spence |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to round down the result of a formula | Excel Worksheet Functions | |||
| How do I get formula result of 3.56 to round up to 4 automatic? | Excel Worksheet Functions | |||
| How do I get formula result of 3.56 to round up to 4 automatic? | Excel Worksheet Functions | |||
| how do I round up a result of a formula in Excel | Excel Worksheet Functions | |||
| How to round up the result in a cell containing formula | Excel Worksheet Functions | |||
Threaded Mode
