VBA Capturing last text character in a cells calculation

[cogswel__cogs]

Hi how could I in VBA identify if the cell last mathematical calculation had a ")" at end?

((IFERROR((SUM($D444:$O444)/$R444*12)*VLOOKUP(Sheet1!$A883,Control!$A$5:$U$28,IF($Q883="Inpatient",6,7),FALSE)*VLOOKUP(Sheet1!$A883,Control!$A$5:$BB$28,IF($Q883="Inpatient",COLUMN()+6,COLUMN()+18),FALSE),0))*0.15)

((IFERROR((SUM($D444:$O444)/$R444*12)*VLOOKUP(Sheet1!$A883,Control!$A$5:$U$28,IF($Q883="Inpatient",6,7),FALSE)*VLOOKUP(Sheet1!$A883,Control!$A$5:$BB$28,IF($Q883="Inpatient",COLUMN()+6,COLUMN()+18),FALSE),0))*0.15)

 

[cogswel__cogs]

Found it using

ans = right(cells(1,1).formula,1)