Excel Conditional Formula Update
Budget / SalaryC$30–250
TypeFreelance project
LocationRemote
Posted1 hour ago
I’m refining a worksheet where cell E9 can contain one of several exact keywords—BCP, FIRE, FLOOD, INFECT, MUD, S, SPRING, SNOW, STRIKE or RADIUS.
When E9 equals any one of those words, I need the formula to return K3 × H9. If none of the keywords are present, it should instead return H9 × K9 × J3. I already have a working snippet for the single-word case:
=IF($E9="S",K$3*H9,$H9*K9*J$3)
Your task is to expand this so every keyword is handled cleanly in Microsoft Excel, respecting exact matches only (no partial strings) and keeping the logic readable for future maintenance.
Deliverable: a single, ready-to-paste Excel formula that produces the correct result in all scenarios, plus a brief note explaining how it works so I can adapt it later if my keyword list grows.
When E9 equals any one of those words, I need the formula to return K3 × H9. If none of the keywords are present, it should instead return H9 × K9 × J3. I already have a working snippet for the single-word case:
=IF($E9="S",K$3*H9,$H9*K9*J$3)
Your task is to expand this so every keyword is handled cleanly in Microsoft Excel, respecting exact matches only (no partial strings) and keeping the logic readable for future maintenance.
Deliverable: a single, ready-to-paste Excel formula that produces the correct result in all scenarios, plus a brief note explaining how it works so I can adapt it later if my keyword list grows.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.