HCBBS Forum (English)
HomeForumView Original
Submit Chemical Projects / Find Solutions
Amplify Your Requirements on a Broader Chemical Platform *Engineering · Technology · Equipment · Solutions*
Submit Request
English Translations » 历史存档[信息] » What does this formula mean in the process design table? Ple

What does this formula mean in the process design table? Please provide an explanation

2015-08-06View Original

Thread Content

Hey guys, in one of our process design sheets, there’s an Excel formula I can’t understand. Does anyone know what it does? I’d appreciate some clarification: =IFERROR(SUM(--(Sales_Costs!$B$4:$B$199=$F25)*(Sales_Costs!$E$4:$E$199="Common")*(Sales_Costs!$D$4:$D$199))%%*$G25/SUMIF($F$5:$F$114,$F25,$G$5:$G$114),0)
Reply #22015-08-06
The emoji above is a * symbol. . . .
Reply #32015-08-06
I suggest you upload this table; we will use it to explain what EXCEL means. What do you say?
Reply #42015-08-11
Hehe, I asked my supervisor to explain what it means; thank you~~~ This formula is used to select values based on certain conditions~~~

Related Threads in This Forum

← Previous

Next →

Translated at 2026-07-21 01:54:48

Original: https://bbs.hcbbs.com/thread-1426304-1-1.html

© 2026 HCBBS Forum. Content translated for international readers.

Submit a Project

**Looking for Chemical Technology, Equipment & Solutions?** No Registration Required Broader Platform Exposure | Global Chemical Service Provider Connections

Submit Request — Free Consultation

Disclaimer

This is an automated machine translation of the original thread. Some technical terms may have inaccuracies; the original text shall prevail. Click "View Original" at the top right to access the source page, which supports IP-based automatic real-time language translation. Please watch out for contact details and sales inducements to prevent fraud. All content and translations are for reference only, representing solely the poster's personal views. For enquiries, email service@hcbbs.com.

Quick Links