Jan 02 2022 02:35 AM
Hello,
Only the expression false works for me in this formula. I used naming for the table. I entered a formula for one cell, the rest were automatically extended. Question: What needs to be done to make the expression true work?
Microsoft® Excel® for Microsoft 365 MSO (version 2111 assembling 16.0.14701.20254)
Jan 02 2022 03:15 AM
AND() combines result for entire row. Use something like
=Цена*Количество*IF( (Выручка < 30000)*(Стаж < 5), 0.05, 0.075)
See attached.