If function

Copper Contributor

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?

4 Replies

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

@CRP-19751415 

It looks like you mean IFS

=IFS(F8>89;"A";F8>79;"B";F8>69;"C";F8>59;"D";true;"F")

@Sergei Baklan Thanks that was what I was looking for :)

@CRP-19751415 , you are welcome