Formula help

serge

Well-known Member
Joined
Oct 8, 2008
Messages
1,264
Office Version
  1. 2007
Platform
  1. Windows
What formula should be use to return 1 ?

if :

A1: 1
B1: 2
C1: 2
in that order ?
OR

A1: 0
B1: 2
C1: 3

I will have different column for each different return.

Thank you.
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
10,846
Office Version
  1. 2019
Platform
  1. Windows
For the first, must be array confirmed with shift ctrl enter.

=--AND(A1:C1={1,2,2})

Same principal applies for the second and any other arrays.
 

serge

Well-known Member
Joined
Oct 8, 2008
Messages
1,264
Office Version
  1. 2007
Platform
  1. Windows
Hi Jason,

It worked like a charm, Thank you so much!!
 

Watch MrExcel Video

Forum statistics

Threads
1,108,999
Messages
5,526,167
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top