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 allmy columns how do i fix this so it can say YHow 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!