Dec 04 2018 08:33 AM - edited Dec 04 2018 09:09 AM
I just created a function in VBA within excel and I have questions about how to apply the function into my workbook. (Specific question and details in response)
Dec 04 2018 08:51 AM
Dec 04 2018 09:05 AM
Your'e right I was not sure what the actual chances of being answered or seen were. Below is the function I have created as seen in the code window of VBA. My question deals with using the custom function itself. When inputting this function into a cell within the workbook =TotalAttendanceCost() I am confused as to which inputs/what format I actually put into the equation.
Dec 05 2018 12:33 AM
To be honest, there is no point in using a VBA function for this simple calculation. Suppose you have your information laid out as follows:
the number of members attending the annual meeting: Cell A2
the cost per member to attending the meeting: Cell B2
the total number of people (members plus guests) attending the annual meeting: Cell C2
the cost for lunch provided at the meeting: Cell D2
the taxes incurred for each meal: Cell E2
In cell F2 you can calulate the Total Attendance Cost using:
= (A2*B2)+(C2*D2)*(1+E2)