Hi
I'm trying to hide a #VALUE return using IF(ISERROR(formula),"",formula),
but excel doesn't like it.
the #VALUE is returned by =IF(F14<>0,F14-O14-P14,"") when there is no value in O14
the formula in O14 is =IF(SUMIF(Purchases!$E$6:$E$999,$D14,Purchases!$I$6:$I$999)<>0,SUMIF(Purchases!$E$6:$E$999,$D14,Purchases!$I$6:$I$999),"")
When I try =IF(ISERROR(IF(F14<>0,F14-O14-P14,""),"",(IF(F14<>0,F14-O14-P14,"")
Excel bounces the formula highlighting the first P14 as the problem, but this is either a blank cell or has a numeric value.
My brain is addled what am I doing wrong?
Bookmarks