Ask Your Question
0

ISBLANK & IF or Dependent Formula

asked 2017-04-05 03:14:38 +0200

thebaldeagle gravatar image

Hello All,

I am looking for a combination of IF and ISBLANK.

Ideally, if a reference cell elsewhere is blank, then the formula cell should be blank, however, if it is not, then I want a simple subtraction.

This is what I have tried, but with Err:508:

=IF(ISBLANK(C2," "),C2-36)

Any help would be greatly appreciated!

Thanks, Baldy.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2017-04-05 09:28:19 +0200

karolus gravatar image

Hallo

=IF(ISBLANK(C2),"",C2-36)

btw. its bad by design to fill cells with nothing but space!

edit flag offensive delete link more

Comments

The formula doesn't conditionally place space(s) in a cell but the empty text which is the formula result next to making the cell blank what not is feasble by a formula. I often used succesfully this kind of "conditionally making de-facto-blank" to have a way to treat cells containing an IF formula along with native blank cells by one of the conditions CellRef="" or CellRef<>""

Lupp gravatar imageLupp ( 2017-04-05 10:59:39 +0200 )edit

The original Formula was intented to insert " " space, in case ISBLANK(C2)

karolus gravatar imagekarolus ( 2017-04-05 11:23:01 +0200 )edit

I now see. Thanks.

Lupp gravatar imageLupp ( 2017-04-05 11:25:27 +0200 )edit
0

answered 2017-04-16 02:35:57 +0200

thebaldeagle gravatar image

Wonderful - Thank you for your help. That was exactly what I was looking for.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-04-05 03:14:38 +0200

Seen: 3,829 times

Last updated: Apr 16 '17