hello team
i am new on this thread and in excel i am a complete novice and trying to learn . My requirememnt is below
Amount of Vitamins and Minerals < 1% 0
Amount of Vitamins and Minerals ≥ 1% to < 2% all cases 2%
Amount of Vitamins and Minerals ≥ 2% to ≤ 10% round to nearest multiple of 2 %
Amount of Vitamins and Minerals >10% to ≤ 50% round to nearest multiple of 5 %
Amount of Vitamins and Minerals >50% round to nearest multiple of 10%
i tried
=IF(M22<50.01,0),IF(0.01<=M22<0.02,0.02),IF(0.02<=M22<=0.1,MROUND(M22,0.02),IF(0.1<M22<=0.5,MROUND(M22,0.05),IF(M22>0.5,MROUND(M22,0.01))))
but somehow i am getting value error
can someone tell me where i am going wrong
Bookmarks