ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Inconsistent Formula (https://www.excelbanter.com/excel-programming/389132-inconsistent-formula.html)

Howard Brazee

Inconsistent Formula
 

If K21 contains =IF($B21=$B20,K20,"") and displays 4,
and L21 contains =IF(ISNUMBER(K21),SUM(C21:K21),"")
then L21 will display 36 with a triangle on it.

If I over type that 4 in K21 to be 4, then the triangle goes away.

If I select the !, I find it is "Inconsistent Formula". I select
"Help on this error", and I get a blank help window.


My real problem may be that I am going about the "Don't show me data
if I haven't created this row yet" issue.


What should I be doing?


All times are GMT +1. The time now is 03:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com