Sunday, May 7, 2017

IF condition in Excel Sheet

=IF(J5>9,"A1",IF(J5>8,"A2", IF(J5>7,"B1",IF(J5>6,"B2",IF(J5>5,"C1",IF(J5>4,"C2",IF(J5>3.2,"D",IF(J5>2,"E1","E2"))))))))
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)