Microsoft Teams Blog articles

Stacked Excel Formula

The user needs a formula in cell K11 of a spreadsheet to count how many values in cells D11, H11, and I11 fall outside specific parameters. These parameters are not explicitly stated, but the user implies a check for values "less than 17" for D11, and similar checks for H11 and I11. The formula should return a numerical count (1-3) in K11, representing the number of cells in the specified range that fail to meet their respective conditions. The user provides examples where all values within parameters result in a 0 in K11, whereas one value outside results in a 1.
favicon
techcommunity.microsoft.com
techcommunity.microsoft.com
Create attached notes ...