Formulas apparently working don't pass for some options

Copper Contributor

Hello,

 

I have an issue with my Excel file. I have some boards linked by formulas. Normally I checked more than 2 times, it should be ok. But some boxes don't fill as they should. Would you have an advice? 

 

I give you the file, it is for the tabb "07.19", where the totals of the lines with the red indicator should appear in the board down right.

 

Thanks a lot !

3 Replies
Formulas are working properly. If there is a result you think is wrong, please tell us which one. Most likely you're seeing a value with a format applied and it looks wrong to you, but the underlying value is calculated correctly.

@Zack Barresse 

 

Hi, 

 

Thank you for having  look!

Few cells are wrong, for example: in tab '07.19', the combinaison C11-D11-E11 corresponds to the cells 

N136-O136-P136. The total in K11 should appear in Q136, but it doesn't.... I can't get why !?

 

Thanks a lot for your help !

Auriane

I finally got it solved, it was a problem of format!

Thanks again for your attention