cogswel__cogs
Board Regular
- Joined
- Jan 3, 2018
- Messages
- 179
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)
((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)