Find the maximum value over three variables.

Topic

New Reply

A transactional spread sheet has the time required to complete three processes.
Step1 step2 step3 are three different variables that can take 1 to 10 days to complete, I need to find a formula that looks at step 1 step 2 and step 3 and returns which step has the maximum value.
So in the case that step 1 = 1 step2 =2 and step3= 3 then the maximum value is ‘’step3 ‘’.
In the case where step 1 = 1 step2 =4 and step3= 4 the value retuned is ‘’step2 and step3’’.
In the case where step 1 = 4 step2 =4 and step3= 4 the value returned is ‘’step1, step2 and step3’’

Is there a formula approche or must it be done by a complicated if. Additionnally I would also like to return the value of the maximum process.

Reply | Quote

Replies

r3x3,

Assuming the values are in cols A, B, C {step 1, 2, 3} then =Max(a1:c1) will return the maximum VALUE. As for returning a list of those steps that equal the maximum value once it is determined assuming it is in column D:
[noparse]=CONCATENATE(IF(A1=D1,”Step1 “,””),IF(B1=D1,”Step 2 “,””),IF(C1=D1,”Step 3″,””))[/noparse] :cheers:
30221-Steps

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Soory for the delay, my internet connection died

Reply | Quote