Forum Discussion
Problem with IF Function
I am trying to calculate a number of cells and need to use the IF function. The calculation is IF H13>7.74, H13,SUM(H12,H13,H14, etc.) but if H10:I11 is blank then put H13. Here is the formula th...
First of all, if you need to sum H12 to H20, use SUM(H12:H20) instead of listing all the cells separated with commas.
The error you see is related to the LEN function: that function gives you the number of character of a single cell. This means that "LEN(A1)" if A1 is "cat" is 3, if it's "frog" it's 4 and so on.
It has nothing in common with times and hours, but the important part is that that LEN function works on a single cell only.
Try changing LEN with COUNTA and see if I got what you need.