Feb 11 2018
11:52 PM
- last edited on
Jul 25 2018
11:01 AM
by
TechCommunityAP
Feb 11 2018
11:52 PM
- last edited on
Jul 25 2018
11:01 AM
by
TechCommunityAP
Feb 12 2018 12:19 AM
That could be like
=IF(SUM(--(A1={0,12,18,21}))*SUM(--(A2={1,2,3,4,"SR","HR"}))*SUM(--(A3={3,3.5,4})),"x","")
for A4 if you mean OR condition for values to check with A1, A2, A3
Feb 12 2018 01:38 AM
Feb 12 2018 02:08 AM
Hi,
Do you mean values in column E are predefined? If, for example, you enter somewhere in 3 cells values 6, 2 and 3 the result in fourth cell shall be picked-up from E and equal to 6448?
Feb 12 2018 02:19 AM
Feb 12 2018 02:31 AM
But in this case you have to define why, for example, 6, 2 and 3 in A,B and C corresponds to 6448, not to other value. You may do that in the table or by some algorithm. Other words, how Excel knows which value to put in E depends on what we have in A, B and C.