Can Open Office do this?

does the forum not display greater than and less than signs?

well, the first one should be GREATER THAN 2, second is LESS THAN 2 and the third is 2.

It's actually easier to just ommit the first part of the number.

omit*


So rather than a 3 digit number i'll use 2.

first sign of madness...

haha i know.


unless anyone can show me how i think it might be easier to just use the digits after the decimal point and then have seperate sheets for each of the variables.

paddys revenge 13 Apr 15:33


first sign of madness...

suggs walking up your front path...

the numbers before the point i mena

actually, it would also work if i used the equation

=(A3/2) - 0.05

maybe not.

=(A3/2)+0.5

there we go. now i can have all three digits included.

is this what you are trying to say:

=IF(A1>2,B/2+1.5,IF(A1<2,B/2+1,1.5))

The B needs to be a cell location with a value in it or a defined value put in name manager.

and yes it will work in open office.

cheers mate, i've done it in a different way. i've put one formula for numbers greater than two in one cell and for less than 2 in another and it seems to work.

but i'll save that anyway for future reference. could be handy for anything more than one or two cells.

CM, just wondering, in my example, B is the second part of a number

i.e

2.00

=

2.BB

Is that the way you did your formula?

No, I did not know what the B related to.

If it is the decimal part of the number in Cell A1 and you wanted to
divide only the decimal by two if the cell is more than or less than 2

=IF(A12,RIGHT(A1,2)/2+1.5,IF(A12,Right(A1,2)/2+1,1.5))

Only works if there are two decimals if more decimals it would need a len() formula
to know what needs to be divided.

That may be what you want, if not a bit more info might help.
Give me an instance of your full number in Cell A1 is and what your answer
should be and I will give you the formula.

If your cell A1 is 3.65, it is more than 2 do you want to divide by 2 only the .65 or
all of the number that is more than 2 ~ i.e. 1.65

I copied and pasted the formula so it did not put in the > sign
so the formula should be
=IF(A1>2,RIGHT(A1,2)/2+1.5,IF(A1<2,RIGHT(A1,2)/2+1,1.5))

Try again
=IF(A1>2,RIGHT(A1,2)/2+1.5,IF(A1<2,RIGHT(A1,2)/2+1,1.5))

If your cell A1 is 3.65, it is more than 2 do you want to divide by 2 only the .65 or
all of the number that is more than 2 ~ i.e. 1.65

Cheers for your time,

I want to divide the .65 by 2

but then add two to whatever the answer is.

So

A1 B1

3.65 2.32

^^^ but that's only correct for a value greater than 3.00

If it less than 2 do you still want to add 2? or some other number?

if less than 2

1+(B/2)

So if A1 was 2.65 what should your answer be?

so

A1 B1

1.99 1.5


'ish

2.65 = 1.63

^ WRONG


2.65 = 1.83


im sure you can see what im trying to do

but no need to blurt it either way!

Got it now. All you need is

=A1/2+.5

see my earlier post:





Rocket to the FACE 13 Apr 15:45


=(A3/2)+0.5

there we go. now i can have all three digits included.




Cheers for your time though. Honestly. It's always nice to get some help from someone who owes you f*ck all. And it's always appreciated and always remembered.

And I'll save the earlier formula you put up because it might be useful.