Need help with the formula

[BuntZMehta]

Hi I am looking formula which will determine the value of a certain cell and apply the same value to other cells simultaneously..

For Eg:-

If J33 is '0', then K33, M33, N33, O33, P33, Q33 & R33 should be '0' as well without I filling it

I have attached an image file for your reference.

Thank you!!

 

[Al Chara]

What should the values be of K33, M33, N33, O33, P33, Q33, and R33, if If J33 does not equal 0?

 

[BuntZMehta]

They should remain Blank otherwise...

I'll have to update them Manually with the appropriate values...

 

[Al Chara]

Are you looking for something like this?

=IF(AND(J33<>"",J33=0),0,"")

or

=IF(J33=0,IF(ISBLANK(J33),"",0),"")

 

[BuntZMehta]

Thanks bro for your prompt replies.. but the solution which you have provides is not working within my cells..

Dont we have an option where we can upload the excel file which I am working on so that you can get an idea of what exactly I am asking you..

 

[BuntZMehta]

Guess what??? Yippie!!
Its working!!!

I had pasted the wrong values on the wrong cell!!

Hats off!!

Thanks a lot!!

 

[BuntZMehta]

Can I post more apt. question here on the same there regarding the formula values if I am stuck somewhere??

 

[BuntZMehta]

The formulas are not getting applied on the cells(ROWS) below.. what do I do??

 

[Al Chara]

The formulas are not getting applied on the cells(ROWS) below.. what do I do??

You should be able to copy and paste the formula to other cells.