Forum Discussion

CRP-19751415's avatar
CRP-19751415
Copper Contributor
Aug 20, 2020

If function

Hi when I try the formula from your homepage (=+if(F8>89;"A";F8>79;"B";F8>69;"C";F8>59;"D";true;"F") I get then NAME? Can you help me?

excel

4 Replies

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Aug 20, 2020

    Hi CRP-19751415

     

    Your formula logical test incorrect, could you please attach the sample file with few data and your desired result to advise you the correct solution.

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

    If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more