lotus formula problem 1

[jab4279]

Hi
Can anyone help with a small formula

I have : Round(column1_*0.75,0)
which gives me 3/4 of the number in column1.

What i need is 3/4 of the number upto a max of 20 and any number over 20 just to treat it as 20
hope that makes sense
jab4279

 

[DonKlein]

Add a third column C and assume B2 is the location of your 75% formula. In C2 use this formula:

@if(+B2>20,20,+B2)

 

[jab4279]

Thaks for that, I don't have @ option so used round
round(if(+B2>20,20,+B2))
this works for numbers 0,1, and 10 upwards but it just enters 20 for numbers 2 to 9 can you shed any light

 

[DonKlein]

I have not upgraded since Lotus 123 97 and am not familiar with a version that does not use the @. What version are you using?

That said, I am suspicious of the "round" in the column C formula. Since the result of the formula in column B is alresdy rounded, why do you need it? What happens if you just use the if?

D

 

[jab4279]

Using Lotus Smart suite 9.8.1 (Approach)
Formula works the same when just using if.
But the same happens ok for numbers 0,1, and 2 then returns 20 for numbers 3 thru 9 Then ok 10 upwards
jab4279

 

[DonKlein]

Since I have no experience with that newer version I am unable to provide further assistance. Maybe someone else will chime in.

Sorry,
Don

 

[jab4279]

ok i have the answer from ibm forum
If((HANDICAP_2 * 1) > 20, 15, Round(HANDICAP_2 * 0.75))
Thanks for your help
jab4279