Help with #value!

[Throughstream]

Hi I've linked one document to another and to avoid getting 0 for blank cells I've used.

=IF('M:\[Master rota.xlsm]Rota week 1'!E33="","",'M:\[Master rota.xlsm]Rota week 1'!E33) which works ok.

However I then use a vba to paste those values to another sheet, still no problem there.

I then have three columns Start time , end time, time difference

I use this formula to show error if the end time is before the start time.

=IF(AH33>AI33,"Error",AI33-AH33)

This is fine if there are values in the cell however if the AH and AI are blank I get #value! I'm gessing it's to do with the fact the "" it's copied over is not a number value. Is there a formula I can use to get round this.

Cheers

[Throughstream]

Think I solved it with:

=IF(AH33>AI33,"Error",IF(AG33="",0,AI33-AH33))

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.