What's Wrong In M14, M15, etc..?

abrogard · April 9, 2021, 8:22am

I’ve written this =IF(ISBLANK(L18),"",IF(L18*210<=H18,“paid”,))

and it only sort of half works and I can’t figure out why.

The failure is demonstrated in M14, M14, M18, M19 etc…

Can someone put me straight please?problemdemo.ods

mikekaganski · April 9, 2021, 8:37am

ISBLANK is documented to return FALSE for cells with formulas - is that your problem?

abrogard · April 9, 2021, 10:15am

could well be. there’s formulas in those cells alright. So is there some variation on isblank I can use?

mikekaganski · April 9, 2021, 10:35am

Just compare to empty string: L18=""

abrogard · April 9, 2021, 10:56am

it wouldn’t let me edit. that was a dumb question I guess. I can use IF(cell="","",“whatever”) I suppose. Not thinking. Put your comment up as an answer and I’ll mark it as the answer. Ah… I see you wrote that when I was doing this. Okay. You want to make it an answer?

mikekaganski · April 9, 2021, 11:19am

ISBLANK is documented to return FALSE for cells with formulas. To compare a cell containing a formula that conditionally returns an empty string, a direct comparison to "" is needed:

IF(L18="";...;...)