To round a certain value, I'm attempting to combine an IF function with a round function. In this instance, cell H2 contains the value. E2 = decimal places There are 9 decimal places if E2=9. I try to utilize this formula (which is only dependent on E2=0 and E2=1), but it does not work.
=IF( E2= 0,ROUND( $H2, 2),IF( E2=1 ,ROUND( $H2, 1))
I receive an error message, something in the syntax has to be fixed. Can someone please help me with this?