Forum Discussion
Formula help - daily pay vs supplement monthly payments
Hi all, I have two sets of data for bonus calculations. SET ONE is in multiple rows by employee, e.g. the annual pay from 1 Jan to 31 Mar. Then 1 Apr to 31 Dec - when their pay has changed from 1 A...
I'm new to this forum so forgive me if this isn't how I need to ask for help with a new issue that I'm having.
You seem very intelligent in your solution posts above on complex issues so here it is.
When I use any FX functions the formulas look bizarre (foreign) and then the correct result doesn't return (here is an example).