Using Excel 2007
If I have a formula in a cell and it gives me a result such as 34.5.....I can move the decimal and have it round up to 35..but is there a way to make it automatically round up and be read as 35...I need ot use the 35 in other formulas but it still seems to read as 34.5 when calculated in other formauls.
If I have a formula in a cell and it gives me a result such as 34.5.....I can move the decimal and have it round up to 35..but is there a way to make it automatically round up and be read as 35...I need ot use the 35 in other formulas but it still seems to read as 34.5 when calculated in other formauls.