Formula error

Originally Posted by mukeshbaviskar:3651677

Hi etaf,
Thank you for formula. It's working fine but only one correction is required. If the student is passed in all six subjects then the remark should be 'P all'. Now it's giving 'F0' which I don't want.

Thank you.

Sincerely,

Mukesh

Hi,

Formula:

 =SUBSTITUTE("F"&SUMPRODUCT((J8:AD8<35)*(MOD(COLUMN(J8:AD8),4)=2)),"F0","P all")