Knowledge Focus: I would like to search for in the designated area A Found to suggest I use = IF (MATCH (; , can not find ,
kobe bryant v, the result is # N / A, I do not know why they can not find without prompting Can not make a comparison with the normal value ,
> 0 is a constant value of 0 ,
lebron iii, it can not compare , so no :
= IF (ISNA (MATCH (B25: B31, 0)), c
cell entry in C2 = IF (B2> 80000,0.4, IF (B2> 60000,0.35,
kobe bryant shoes, IF (B2> 40000,0.3, IF (B2> 20000,0.25, IF (B2> 5000,
nike kobe v, 0.2, IF (B2> 2000,0.15,
kobe v shoes, IF (B2> 500,0.1, IF (B2 0,
nike lebron,0.05,0 ))))))))
First Previous 12 Next Last