Stuck with 3.3 forever?

users
#21

"Johnny Rosenberg" <gurus.knugum@gmail.com> wrote in message news:CADo7T4d47+3cOmv6+rbHbLoeB6wpiLHF3isRFm0O5qmPkcx62Q@mail.gmail.com...

Johnny Rosenberg wrote

I could agree with that, but it would have been nice if they thought
of that since 1.0 and not changing it on the way, breaking a whole lot
of spreadsheets…

I see your point. But this was wrong.
It's not a change of plans it's simply a correction. And not fixing it would
break a lot of other spreadsheets :wink:

Johnny Rosenberg wrote

Is there another way to make A2 look empty in
this case, making it useable for calculations? Something like the
following:
=IF(A1=6;SomethingNiceToPutHere;B1)

<snip>

What happens if you set A3 to be =((A2&"0")/10+27)
So, for example, if A2 is 30, A2&"0" is 300; divide by 10 gives 30 again and then add the 27. But if A2 is "" (empty), A2&"0" should force a numeric zero which stays the same when divided by 10.

#22

Harold Fuchs-4 wrote

So, for example, if A2 is 30, A2&"0" is 300; divide by 10 gives 30 again
and
then add the 27. But if A2 is "" (empty), A2&"0" should force a numeric
zero
which stays the same when divided by 10.

The point here is that =A2&"0" is considered text (you can check with
ISTEXT), so you shouldn't even be able to divide it!

There is a lack of consistency in the classification of cell contents (which
is not exclusive of LO)

In any case the OP wanted a blank cell not a zero (unless he hid it using
Conditional Formatting as I suggested in a previous email)

#23

I can't test that right now, because I have 3.3.4 on this computer. I
left the other computer, with 3.4.4, at work. I usually only take it
home for weekends. Ok, I know how that sounds… ha ha ha…
Still, even if it works, the N() solution seems to be a more obvious solution…

Thanks to everyone who came up with ideas, though. I appreciate it.

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

#24

Correct. About that conditional thing, I don't think it's possible,
since I already use it for other purposes (drawing lines to separate
groups of cells automatically). Well, it's probably possible, but I
would have to create a lot of styles to match every combination of
what I have now and visible/invisible contents, and I'm not sure three
different conditions will be enough. It seems more complicated than
using N() in any case, I think.

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

#25

<SNIP<<

If you enter a number in A1, A3 displays that number+27. If you don't,
A3 displays an error message: ”#VALUE!” (I guess; I didn't test this
particular example…). I want it to display 27.

Thanks anyway for trying to help. :slight_smile:

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

You could use this kind of formula structure:
" =IF(ISNUMBER(A1),A1+27,"") " (without the quotes).
This should do what you want.

Joe Conner, Poulsbo, WA USA