![]() |
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