带有IF语句的Excel ISNUMBER函数 [英] Excel ISNUMBER Function with IF Statement

问题描述

我有一个我正在使用的Excel文件。有一列包含数字和文本，有时它只是一个或另一个。我正在尝试编写一个函数来扫描单元格的最左边部分，看它是否以数字开头。我以为我有它，但显然不是。这就是我所拥有的：

I have an Excel file I'm working with. There is a column that contains numbers and text, sometimes it's just one or the other. I'm trying to write a function that scans the left most part of the cell to see if it starts with a number. I thought I had it but apparently not. This is what I had:

=IF(ISNUMBER(LEFT(E8,1)), "True", "False")

即使特定单元格E8开头，这仍然会给我一个假结果一个3。我在这里缺少什么？

This continues to throw me a "false" result even though that particular cell, E8, begins with a "3". What am I missing here?

推荐答案

试试这个：

=IF(ISNUMBER(VALUE(LEFT(E8,1))),"True","False")

这篇关于带有IF语句的Excel ISNUMBER函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！