Excel 2007 : Help with formula issue for work roster

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