3 calculators merge to 1
-
Hello, I wanted to ask help about merging 3 calculator, which I made with CFF to 1 calculator with extra field, coz their functions are similar, I just can‘t create the merged formula so I wanted to ask a help.
In the new calculator I will add 1 more selection (let‘s call it ‘fieldnameX‘) which includes all 3 parameters below: (those parameters are: ‘gain’ weight; ‘lose’ weight; ‘remain’ same weight).
New field will be called: fieldnameX. This field will have variables: ‘gain’, ‘lose’, ‘remain’.
These 3 calculators and their formulas are:
1. Calculator for gaining weight (link: https://sportuojantys.lt/skaiciuokles/makroelementu-skaiciuokle-auginant-mase/)
Formula for kcal answer:
PREC(fieldname3==’Vyras’?(fieldname4==’3-4 treniruot?s’?42*fieldname2:52*fieldname2):(fieldname4==’5 ir daugiau treniruo?i?’?47*fieldname2:36*fieldname2))2. Calculator for losing weight. (link: https://sportuojantys.lt/skaiciuokles/makroelementu-skaiciuokle-metant-svori/)
Formula for kcal answer:
PREC(fieldname3==’Vyras’?(fieldname4==’3-4 treniruot?s’?28*fieldname2:38*fieldname2):(fieldname4==’5 ir daugiau treniruo?i?’?35*fieldname2:25*fieldname2))3. Calculator for remaining the same weight (link: https://sportuojantys.lt/skaiciuokles/makroelementu-skaiciuokle-palaikant-svori/)
Formula for kcal answer:
PREC(fieldname3==’Vyras’?(fieldname4==’3-4 treniruot?s’?33*fieldname2:42*fieldname2):(fieldname4==’5 ir daugiau treniruo?i?’?39*fieldname2:31*fieldname2))I know that I need more of ?((()))“ symbols in merged formula but I just can‘t figure it out, so maybe you can help me?
Thanks in advance…
The page I need help with: [log in to see the link]
- The topic ‘3 calculators merge to 1’ is closed to new replies.