Forum Discussion
Rounding formula in a cell with an existing formula.
I have the formula below that calculates 10% value where the condition "Yes" is true.
I need to append a rounding formula to limit the cell value to 2 decimal places, assistance would be appreciated.
=IF(D55389="Yes",G55389*0.1,)
=ROUND(IF(D55389="Yes",G55389*0.1,),2)
This will round the outcome to 2 decimals. Note that you would also have to format the cell to display two decimals in all cases. For instance:
100 * 10% = 10 to display 10.00
101 * 10% =10.1 to display as 10.10
100.1999 * 10% = 10.01999 to display as 10.02
2 Replies
=ROUND(IF(D55389="Yes",G55389*0.1,),2)
This will round the outcome to 2 decimals. Note that you would also have to format the cell to display two decimals in all cases. For instance:
100 * 10% = 10 to display 10.00
101 * 10% =10.1 to display as 10.10
100.1999 * 10% = 10.01999 to display as 10.02
- Thank you so much.
