Excel formula to UDF

[rehanemis]

HI,
I am using these formula's to calculate the Grade and Commission as Category/Grade and Commission is also mentioned. I am using these functions and working well. Now I would like to convert my function to UDF so that I can only choose Ach and Ach% and get the Grade and Commission.
Like =GetGrade(B3,C3) and it return grade and same for commission.
I also want a tool tip if possible when entering formula like =GetGrade(Choose Ach, Choose Ach%).

Thanks

 

[Dave Patton]

You can post an extract of your sheet with the forum's tool named XL2BB.

You could consider Excel's Lambda functionality instead of a UDF.
I named the Lambda GetGrade.

The function will indicate the parameters in my example like =GetGrade(Ach,AchP)

LAMBDA(Ach,AchP,LET(a,Ach,p,AchP,IF(AND(a>=50,p>=0.95),"A",IF(AND(a>=25,p>=0.95),"B","C"))))

LAMBDA.xlsm
	A	B	C	D	E
1
2
3		89	99%	A	A
4		35	99%	B	B
5		30	90%	C	C
6
4a

Cell Formulas
Range	Formula
D3:D5	D3	=IF(AND(B3>=50,C3>=0.95),"A",IF(AND(B3>=25,C3>=0.95),"B","C"))
E3:E5	E3	=GetGrade(B3,C3)