Rounding an "IF" Formula

[Ganners]

I need to round this formula to 1 decimal point

=IF(C3=0,"",C3/D3)

HELP

 

[Ultim8]

right click the cell, click format cells, click numbers tab, select number, then change to 1 decimal place.

 

[Ganners]

How do you total a column with "IF" formulas?

 

[CWatts]

Or if you actually want to chop off the data and not just hide it, as formatting is done:

=IF(C3=0,"",ROUND(C3/D3,1))

Generally formatting the cell as mentioned before is better, but there it is if you need another option.

 

[Ultim8]

just use =sum(A1:A10) where A is the column and 1 is the start point and 10 is the end point of what you want to sum