Ask Your Question
0

ISBLANK works sometimes but not others

asked 2017-10-01 14:59:15 +0100

oldbluejeans gravatar image

Ideally I'd like to do this: in cell G5 I have =IF(C5="","',E510), works only if C5 contains data, although on other sheets works fine. So I cut and paste, change formatting, etc still won't work on some sheets. I then tried =IF(ISBLANK(C5),"",E510) with the same result. What am I doing wrong here?

edit retag flag offensive close merge delete

Comments

1

Hard to tell without sample problematic workbook

Mike Kaganski gravatar imageMike Kaganski ( 2017-10-01 15:08:46 +0100 )edit
1

And please edit your question don't add an answer if it is not. Adding the LibreOffice version would be fine.

m.a.riosv gravatar imagem.a.riosv ( 2017-10-02 01:24:26 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2017-10-01 17:15:58 +0100

oldbluejeans gravatar image

Ideally I'd like to do this: in cell G5 I have =IF(C5="","',E5 * 10), works only if C5 contains data, although on other sheets works fine. So I cut and paste, change formatting, etc still won't work on some sheets. I then tried =IF(ISBLANK(C5),"",E5 * 10) with the same result. What am I doing wrong here? I reposted this to get the correct formulas in the question. I have what I would call more of a work-around than a solution. And that's to use: IF(C5="",0,E5 * 10). While the original works on some sheets, this seems to work anywhere. Reformatting has no effect.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-10-01 14:59:15 +0100

Seen: 115 times

Last updated: Oct 01 '17