Trevor3007
Well-known Member
- Joined
- Jan 26, 2017
- Messages
- 667
- Office Version
- 365
- Platform
- Windows
Hi,
I dont even know if my request is possible? But here goes. The screenshot below , a customer has this spreadsheet which he gets exported from his companies payroll. As it differs from month to month he cannot just place the apllicable =sum() in the same row as last ime as the value in cols d & e will change.
So, rather than doa nested =if, is there it possible to have VB do it?
Col 'I' would display the total using the rate displayed in col 'd' x the hours in col 'E' x £8.30.
many thanks & good luck.
I dont even know if my request is possible? But here goes. The screenshot below , a customer has this spreadsheet which he gets exported from his companies payroll. As it differs from month to month he cannot just place the apllicable =sum() in the same row as last ime as the value in cols d & e will change.
So, rather than doa nested =if, is there it possible to have VB do it?
Col 'I' would display the total using the rate displayed in col 'd' x the hours in col 'E' x £8.30.
many thanks & good luck.