IF forumla needs revision.

[NKRA]

Hello All,

Attached workbook I had solved using support from forum members(thanks). Now I have another need(enhancement) on file.

In Column Y, Cell Y3 the totals are derived based on selection of Product in Cell 12 and Quality type in Cell 13... which is working fine.

Need a update on my formula

Forumula should check if anytime Value in all Column J, K, L is zero then Column Y total should also become zero. For example J3, K3, L3 is Zero in curent attached but still Y3 provide input because of my nested IF function.

Please help.

Attached should explain.

[JBeaucaire]

Please Login or Register  to view this content.

[NKRA]

Thanks Formula work as provided

Is there a way to get Zero instead of blank output because i have further formulas depedent on column Y.

NK

[JBeaucaire]

Change those double quotes to a zero

Please Login or Register  to view this content.