Ask Experts Questions for FREE Help !
Ask

Search:

Type: Posts; User: ArcSine

Search: Search took 0.00 seconds.

  1. Roger that. Small thing: If you define your...

    Roger that. Small thing: If you define your breakpoints as 89, 79, ..., as I have in my example, rather than 90, 80, etc., then your inequalities in the formula can be strict ">" rather than of the...
  2. You can. Excel's IF() operates like C's (if this...

    You can. Excel's IF() operates like C's (if this ? then this : otherwise this). Taking advantage of the left-to-right processing of the nested IFs:

    =IF(D3 > 89, "A", IF(D3 > 79, "B", IF(D3 > 69,...
Results 1 to 2 of 2