# Thread: Find the maximum value over three variables.

1. ## Find the maximum value over three variables.

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.

2. 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:
=CONCATENATE(IF(A1=D1,"Step1 ",""),IF(B1=D1,"Step 2 ",""),IF(C1=D1,"Step 3",""))
Steps.JPG

3. ## thankyou it works great

Soory for the delay, my internet connection died

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•