Hi there,
Im creating a work roster and the only issue I have had is that I want one column to add all the paid work that day. The issue is that if they haven't worked that day then the end result is a #VALUE! error. This error then extends to the general calc I have to calc all the paid work and returns a VALUE error too.
At the moment it's just =e6-a130, but both e6 and a130 are blank (because that staff memebr didnt work) so it returns the #VALUE! error and I need it to return a 0 preferablly.
Never mind, sorry for the post!
Solved with
=IFERROR(E6-A130,0)
Thanks to anyone that looked
Cheers
Tim
Bookmarks