如何驗證多個儲存格是否為同一個值?

%3CLINGO-SUB%20id%3D%22lingo-sub-1870001%22%20slang%3D%22zh-CN%22%3EHow%20do%20I%20see%20%E5%84%B2%20the%20same%20value%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1870001%22%20slang%3D%22zh-CN%22%3E%3CP%3EHello%2C%20I'd%20like%20to%20ask%20how%20to%20quickly%20%E5%84%B2%20the%20same%20value%3C%2FP%3E%3CP%3EIf%20I%20want%20to%20see%20if%20the%20%E5%84%B2%20A1%20to%20E1%20is%20the%20same%20value%3C%2FP%3E%3CP%3EI'll%20do%20it%20all%20by%20hand%3C%2FP%3E%3CP%3EThat's%20what%20my%20letter%20will%20do%3C%2FP%3E%3CP%3Eif%20(And%20(A1-B1%2C%20B1-C1%2C%20C1-D1%2C%20D1-E1)%2C%20%22same%22%2C%20%22different%22)%3C%2FP%3E%3CP%3EBut%20if%20I%20had%20more%20than%20100%20%E5%84%B2%2C%20it%20would%20be%20a%20bit%20stupid%2C%3C%2FP%3E%3CP%3EWant%20to%20ask%20if%20there%20is%20any%20way%20to%20more%20quickly%20%E5%84%B2%20the%20same%20value%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1870001%22%20slang%3D%22zh-CN%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1872296%22%20slang%3D%22de-DE%22%3ERE%3A%20%E5%A6%82%E4%BD%95%E9%A9%97%E8%AD%89%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E6%98%AF%E5%90%A6%E7%82%BA%E5%90%8C%E5%80%8B%E5%80%BC%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1872296%22%20slang%3D%22de-DE%22%3E%E7%BF%BB%E8%AF%91%E8%8B%B1%3A%20%E8%BF%99%E5%BA%94%E8%AF%A5%E6%98%AF%E8%BF%99%E6%A0%B7%20%3D%20IF(AND(A1%20%3D%20B1%2CB1%20%3D%20C1)%2C2.0)%20%E5%8F%A6%E7%A7%8D%E5%8F%AF%E8%83%BD%E6%80%A7%E6%98%AF%3A%20%3DEXACT(B2%2CB10)%20%E6%88%91%E5%BE%88%E6%88%91%E6%98%AF%E5%90%A6%E5%8F%AF%E4%BB%A5%E5%B8%AE%E5%BF%99%E5%85%B4%20%E5%B0%BC%E5%9F%BA%E5%88%A9%E8%AF%BA%20%E6%88%91%E7%9F%A5%E9%81%93%E6%88%91%E4%BB%80%E4%B9%88%E9%83%BD%E4%B8%8D%E7%9F%A5%E9%81%93(%E8%8B%8F%E6%A0%BC%E6%8B%89%E5%BA%95)%20*%E5%A6%82%E6%9E%9C%E5%8F%AF%E4%BB%A5%E5%B8%AE%E5%8A%A9%E6%82%A8%2C%E8%AF%B7%E5%9C%A8%E6%AD%A4%E5%9B%9E%E5%A4%8D%E4%B8%AD%E6%B3%A8%E6%98%8E%E5%B9%B6%E6%8A%95%E7%A5%A8%2C%E5%9B%A0%E4%B8%BA%E8%BF%99%E5%AF%B9%E6%9B%B4%E5%A4%9A%E9%98%85%E8%AF%BB%E6%AD%A4%E5%A4%84%E7%9A%84%E7%A4%BE%E5%8C%BA%E6%88%90%E5%91%98%E8%80%8C%E8%A8%80%E6%98%AF%E6%9C%89%E7%9B%8A%E7%9A%84%E3%80%82%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

您好,我想請問如何快速驗證多個儲存格為同一個值

假設如果我要驗證A1~E1的儲存格是否為同一個值的時候

我都會用手動的方式key-in函數

我的函數會長這樣

if(And(A1=B1,B1=C1,C1=D1,D1=E1),"same","different")

可是如果我有超過100個儲存格時,這方法就會顯得有些愚笨,

想請問有沒有什麼方式可以更快速的驗證多個儲存格是否為同一個值呢?

1 Reply
Highlighted
翻译成英文: 这应该是这样的 = IF(AND(A1 = B1,B1 = C1),2.0) 另一种可能性是: =EXACT(B2,B10) 我很高兴知道我是否可以帮忙。 尼基利诺 我知道我什么都不知道(苏格拉底) *如果可以帮助您,请在此回复中注明并投票,因为这对更多阅读此处的社区成员而言是有益的。