• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IF blank do not apply roundup

Anand307

Member
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
 

Attachments

  • Book1.xlsx
    12.6 KB · Views: 0
Hi,

Not very clear as to what you are looking for..however, this is my wild guess...

Wrap the above formula in one more if condition...

IF($C$5="",D15,ROUNDUP(IF(C36>$C$31,C36,0),-4))

If this doesnt help, can you share an example with the expected result...
 
I have provided an example for you in attached please let me know if any questions.
 

Attachments

  • Book1.xlsx
    11.1 KB · Views: 0
Perfect, Thank you Asheesh and all Chandoo team. it feels so good to be a member on this forum where we always have good people to help in sharing knowledge.:):)
 
Back
Top