Conditional Formula inside Family to be use in Schedule

[nichkherbsman]

Hi,

Good day. I need help to achieve the formula inside a certain family to be used in formula. I am aiming actual length, just like images below : 

So I tried to make this rules / condition but can't find the correct statement for parameters.

Cap end = 12mm
I will consider the rules for this:

If the LED Drawing length is less than 1800 then (LED Drawing length - Cap end)/25 = Actual number of LED(rounddown)
(Acutal number of LED * 25)+12 = Actual Length of LED

If the LED Drawing length is greater than 1800 but less than 3600 then ((LED Drawing length-(Cap end*2) / 2) = LED Drawing length A
LED Drawing length A / 25 = Acutal number of LED A (rounddown)
(Acutal number of LED A * 25)+12 = Actual Length of LED A

((LED Drawing length-(Cap end*2) -LED Drawing length A) = LED Drawing length B
LED Drawing length B / 25 = Acutal number of LED B (rounddown)
(Acutal number of LED B * 25)+12 = Actual Length of LED B

If the LED Drawing length is greater than 3600 then ((LED Drawing length - (Cap end*3) / 3 ) = LED Drawing length A
LED Drawing length A / 25 = Acutal number of LED A&B (rounddown)
(Acutal number of LED A * 25)+12 = Actual Length of LED A & B

((LED Drawing length-(Cap end*3) -LED Drawing length A+B) = LED Drawing length C
LED Drawing length C / 25 = Acutal number of LED C (rounddown)
(Acutal number of LED B * 25)+12 = Actual Length of LED C

I attached some revit sample and family

[nichkherbsman]

Hi,

Good day. I need help to achieve the formula inside a certain family to be used in formula. I am aiming actual length, just like images below : 

So I tried to make this rules / condition but can't find the correct statement for parameters.

Cap end = 12mm
I will consider the rules for this:

If the LED Drawing length is less than 1800 then (LED Drawing length - Cap end)/25 = Actual number of LED(rounddown)
(Acutal number of LED * 25)+12 = Actual Length of LED

If the LED Drawing length is greater than 1800 but less than 3600 then ((LED Drawing length-(Cap end*2) / 2) = LED Drawing length A
LED Drawing length A / 25 = Acutal number of LED A (rounddown)
(Acutal number of LED A * 25)+12 = Actual Length of LED A

((LED Drawing length-(Cap end*2) -LED Drawing length A) = LED Drawing length B
LED Drawing length B / 25 = Acutal number of LED B (rounddown)
(Acutal number of LED B * 25)+12 = Actual Length of LED B

If the LED Drawing length is greater than 3600 then ((LED Drawing length - (Cap end*3) / 3 ) = LED Drawing length A
LED Drawing length A / 25 = Acutal number of LED A&B (rounddown)
(Acutal number of LED A * 25)+12 = Actual Length of LED A & B

((LED Drawing length-(Cap end*3) -LED Drawing length A+B) = LED Drawing length C
LED Drawing length C / 25 = Acutal number of LED C (rounddown)
(Acutal number of LED B * 25)+12 = Actual Length of LED C

I attached some revit sample and family

[mhiserZFHXS]

https://knowledge.autodesk.com/support/revit/learn-explore/caas/CloudHelp/cloudhelp/2020/ENU/Revit-M...

Basically

if (given condition, value if true, value if false)

Or if using a yes/no parameter

if (parameter, value if yes, value if no)

[mhiserZFHXS]

https://knowledge.autodesk.com/support/revit/learn-explore/caas/CloudHelp/cloudhelp/2020/ENU/Revit-M...

Basically

if (given condition, value if true, value if false)

Or if using a yes/no parameter

if (parameter, value if yes, value if no)