Hi all,
My head is wrecked today trying to do this.
I want to allocate wages on a cost by site basis.
E.g. Employee 1
€100 gross wages
60% site A, 40% site b
No problem for that, but because I have multiple sites (Sites a - f) and different employees on each site, when I try to get a value of zero or blank for Employee 1 on site c, it returns #VALUE!, so I can't add the column.
Is there a formula you can use to display a blank cell, if the result is zero? Or alternatively only display cell if value is €0.01 or more?
I would be very grateful for any help,
Ginger
My head is wrecked today trying to do this.
I want to allocate wages on a cost by site basis.
E.g. Employee 1
€100 gross wages
60% site A, 40% site b
No problem for that, but because I have multiple sites (Sites a - f) and different employees on each site, when I try to get a value of zero or blank for Employee 1 on site c, it returns #VALUE!, so I can't add the column.
Is there a formula you can use to display a blank cell, if the result is zero? Or alternatively only display cell if value is €0.01 or more?
I would be very grateful for any help,
Ginger