Hi. I'm trying to change this formula
to give results for the nearest 5. I used mround(c8,5) and round(c8/5,0)*5 like this
and it still gives me to the nearest integer.
Any help would be appreciated!
Code:
IF(AND(MOD(ROW(),2)=0,B8<>"",C8<ROUND(C8,0)),ROUND(C8,0),IF(AND(MOD(ROW(),2)=0,B8<>"",C8>=ROUND(C8,0)),CEILING(C8,1),IF(AND(MOD(ROW(),2)=1,B8<>""),E7,"")))
to give results for the nearest 5. I used mround(c8,5) and round(c8/5,0)*5 like this
Code:
IF(AND(MOD(ROW(),2)=0,B4<>"",C4<MROUND(C4,5)),MROUND(C4,5),IF(AND(MOD(ROW(),2)=0,B4<>"",C4>=MROUND(C4,5)),CEILING(C4,1),IF(AND(MOD(ROW(),2)=1,B4<>""),E3,"")))
and it still gives me to the nearest integer.
Any help would be appreciated!