Excel formula

Occasional Visitor

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)2022-01-02 (2).png2022-01-02 (3).png

1 Reply

@Bryntsev_Igor 

AND() combines result for entire row. Use something like

=Цена*Количество*IF( (Выручка < 30000)*(Стаж < 5), 0.05, 0.075)

See attached.