My below formula is giving errors, requirement is if H6 is >6 result should be 40% of H6 and if H6 is <6 result should be 30% of H6, in both case answer should be round up to nearest by 0.5 (i.e 4x30% = 1.5 instead of 1.2 & 7x40% = 3 instead of 2.8)
=IF(H6<6,CEILING,(0.3*H6, 0.5)), IF(H6>6, CEILING,(0.4*H6, 0.5))
Please help
Bookmarks