Nearest 5 integer

[phil133]

Hi. I'm trying to change this formula

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

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!

 

[phil133]

Nevermind I had to change ceiling(c4,1) to ceiling(c4,5)