How to apply if condition used in excel to place value decimal place?
Answers
Answered by
0
Select the cells to which you wish to apply a conditional number format.
2. Press Ctrl-1 to display the Format Cells dialog box. In Excel 2007 and later, you can click the Number button on the Home tab, as shown in Figure 1. Or, in Excel 2003 and Excel for Mac, choose Format and then Cells.
3. Choose Custom from the Number tab of the Format Cells dialog box.
4. Enter the following formatting code in the Type field: [>=1]#,##0;[<1]0.00
5. Click OK to close the Format Cells Dialog box.
2. Press Ctrl-1 to display the Format Cells dialog box. In Excel 2007 and later, you can click the Number button on the Home tab, as shown in Figure 1. Or, in Excel 2003 and Excel for Mac, choose Format and then Cells.
3. Choose Custom from the Number tab of the Format Cells dialog box.
4. Enter the following formatting code in the Type field: [>=1]#,##0;[<1]0.00
5. Click OK to close the Format Cells Dialog box.
Similar questions