What formulas could work for this requirement?

Your client has a requirement to set a custom Amount column called RSU Shares to 15 if the employee has a performance rating of 5 and a Pay Grade of 6 or 7. If the employee does not meet these conditions, then they receive 0 shares.

What formulas could work for this requirement? Note There are 2 correct answers to this question.
A . if(pmRating=5&&(payGrade=6| 7).15.0)
B . iflpmRaling=5&&(payGrade=6| payGrade=7) 15 0)
C . if(pmRating=5 AND payGrade=6 OR payGrade=7 15,0)
D . if(pmRating=5.if(payGrade=6 l5.if(payGrade=7 15.0)) 0)

View Answer

Answer: B D