I am trying to have two formulas on the same line because I wanna hide my cells while..

[TristanB]

There's a bug somewhere but the formulas are so complex that I don't wanna find the bug since I am too noob with excel I just want to be able to add an IF formula that would allow me to hide the cells next to my cell if the value is 0 on the cell next to it! So this is the formula I have in cell

=SI(ESTERREUR(RECHERCHEV($A26,Sommaire!$A$19:$E$86,2,FAUX)),"",RECHERCHEV($A26,Sommaire!$A$19:$E$86,2,FAUX))

I wanna add something like if value in $B$13:$B$49 is 0 then turn value to 0 so the cell becomes empty in the row.

because some cells in the C row shows a value like EMB when the cell next to it in B row is empty that's the weird bug!

I've tried everything I am tired


JMtxTgA.png

[AliGW]

Welcome to the forum.

There is no 2021 version - please update your profile to either Excel 2019 or MS365 as appropriate.

There are instructions at the top of the page explaining how to attach your sample workbook.