Dear Sir,
=ROUNDUP(IF(C36>$C$31,C36,0),-4)
This Formula I write in D15, based on C5 I want to add one more thing that is IF C5 is blank then in D15 the rounding formula should not apply and the exact value from C15 Should pickup in D15. Else if there is a value in C5 then the in D15 the roundup formula should apply. Please help
=ROUNDUP(IF(C36>$C$31,C36,0),-4)
This Formula I write in D15, based on C5 I want to add one more thing that is IF C5 is blank then in D15 the rounding formula should not apply and the exact value from C15 Should pickup in D15. Else if there is a value in C5 then the in D15 the roundup formula should apply. Please help