[Solved] Ексель присвоить статус при нескольких переменных . Нужно присвоить статус к определенной группе магазина.

[naity]

Создала формулу =ЕСЛИ(T4<=90%;"дефицит";ЕСЛИ(T4>=120%;"избыток";"ок")) нужно в нее зашить группу магазина. Т.е Для магазина А отклонение от емкости проставляет статус дефицит при <=90%, статус избыток >=120% статус ок все остальное. Нужно для каждой подгруппы, т.к у каждой подгруппы будут свои условия.

 

[shamimarita]

Hello Naity,

Thank you for your question! For better assistance from the community, could you please post your query in English? This will help ensure that more members can understand and respond to your request.

 

[shamimarita]

Hello Naity,

You can use nested IF statements to modify your formula to include different conditions based on store group. Here’s how to structure your formula:

Using Nested IF Statements
Assuming that the store group is indicated in column S and you have specific conditions for Store A, you can use a formula like this:

=IF(S4="Store A", IF(T4<=90%, "deficit", IF(T4>=120%, "surplus", "ok")),
IF(S4="Store B", IF(T4<=85%, "deficit", IF(T4>=115%, "surplus", "ok")),
IF(S4="Store C", IF(T4<=80%, "deficit", IF(T4>=110%, "surplus", "ok")),
"Other Store Conditions")))
Explanation:

• Store A: If the store is "Store A", the formula checks if T4 is less than or equal to 90% for "deficit", greater than or equal to 120% for "surplus", and otherwise returns "ok".
• Store B and Store C: You can specify different conditions for each store. Adjust the percentages according to your requirements.
• The final "Other Store Conditions" part is a catch-all if the store name doesn't match any specified store.