• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Nested IFS Autofill another column issue

Iain A

New Member
Hi I am using the following Nested IF to find 3 conditions, but also want to change the FALSE parts to show the same condition. apologies if I haven't explained that very well. Please see attached. Thanks in advance anyone that can assist.
 

Attachments

Fluff13

Active Member
How about
=IF(OR(B2={"Minimum","Most Likely","Maximum"}),B2,IF(OR(A1={"Minimum","Most Likely","Maximum"}),A1,""))
 
Top