Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is inconsistent formula in region in excel? | Excel Discussion (Misc queries) | |||
HOW TO CATCH A DIFFERENT/INCONSISTENT FORMULA | Excel Discussion (Misc queries) | |||
Inconsistent Formula? | Excel Discussion (Misc queries) | |||
Formula results inconsistent. | Excel Worksheet Functions | |||
Help! ISO formula for inconsistent monthly dates | Excel Discussion (Misc queries) |