Question: How can i fix my formula it keep saying Y to all my columns how do i fix this so it can say Y and

How can i fix my formula it keep saying Y to all my columns how do i fix this so it can say Y and N if true and N/A
3. Create a new column to the right of the Urban Y/N column and label this column as "Warning Gates Y/N to determine if Warning Gates are required for the below criteria, ranked from highest to lowest priority. If warning gates are required, use a "Y", if they are not required, use N, if warning gates are not applicable, use N/A a) Warning gates are "N/A if the value in the "Location" column is "Unknown" or if the value in the "Urban" column is "N/A" (Utilize the OR Function) b) 5 lanes or more require warning gates c) Warning Gates are Y" when the maximum train speed is >80 kph and the type of Access is "Public" (Utilize the AND function) d) Warning gates are NOT required if the above criteria is not met H K L M N O P Q S T U =5,"Y",AND(Z3>=80,F3 2 2N ="Public"), "Y",TRUE,"N") D
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
