=IF(AR15=”outstanding”,2500,IF(AR15=”exceeds”,2000,IF(AR15=”meets”,1500,0)))

This formula has no identified errors but the last argument returns 0 instead of 1500.  outstanding and exceeds work fine.  Appreciate any thoughts.

​=IF(AR15=”outstanding”,2500,IF(AR15=”exceeds”,2000,IF(AR15=”meets”,1500,0))) This formula has no identified errors but the last argument returns 0 instead of 1500.  outstanding and exceeds work fine.  Appreciate any thoughts.  Read More

​