Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
lotus formula problem
ok i have the answer from ibm forum If((HANDICAP_2 * 1) > 20, 15, Round(HANDICAP_2 * 0.75)) Thanks for your help jab4279- jab4279
- Post #7
- Forum: Office suites general discussion
-
lotus formula problem
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- jab4279
- Post #5
- Forum: Office suites general discussion
-
lotus formula problem
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- jab4279
- Post #3
- Forum: Office suites general discussion
-
lotus formula problem
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- jab4279
- Thread
- Replies: 6
- Forum: Office suites general discussion
