Hhow to make a formula to find the maximum value from 3 existing parameters?
Announcement
Collapse
No announcement yet.
MAX value in formula
Collapse
X

Originally posted by antonko View PostHhow to make a formula to find the maximum value from 3 existing parameters?
http://www.revitforum.org/tutorials...dayusage.html
Originally posted by ekkonap View PostTo sort out the largest variable, how about > =if(A>C, if(A>B, A, B), if(B>C, B, C)) ?
It kind of becomes a shambles with 4 or more variables though. Use a matrix to keep your head on straight:
A>D A>C A>B A
B>D B>C B
C>D C
D
=if(A>D, if(A>C, if(A>B, A, B), if(B>C, B, C)), if(B>D, if(B>C, B, C)), if(C>D, C, D))
EDIT=if(A > D, if(A > C, if(A > B, A, B), if(B > C, B, C)), if(B > D, if(B > C, B, C), if(C > D, C, D)))Last edited by Alex Cunningham; November 22, 2011, 02:49 PM.Alex Cunningham

Post #35 Will get you exactly what you are looking for. Just drop the D and keep A, B and C
It will look something like.
20111122_1101  Alex_Cunningham's libraryAttached FilesAlex Cunningham
Comment
Related Topics
Collapse

Hi, I am sure that my question is the basic of formulas and possibly is just a math.
I have 7 Dimensions, one of them is 100% the rest i need to...October 27, 2014, 11:32 AM 
my head hurts after perusing the Revit Formulas for Every Day Usage thread...gah! Hopefully this is simple. I have this formula using length parameters:...August 16, 2013, 01:56 PM

I'm trying to put together a formula to calculate total exit width and have it almost there. The problem pops up when one or more of my fields does not...May 16, 2012, 02:40 PM

Why o why when I try to enter a value on a schedule does it come up with a flag " Enter a value or a formula starting w '=' "? All the other...October 30, 2012, 10:29 PM

I have created this formula to look at the length of a given stud and determine if its greater than 4' then divide by 10' or if its smaller than 4' just...January 29, 2014, 06:00 PM
Comment