Help with formula #value! Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The formula below worked fine until the management requested that column AO11 be added. I have added column AO11 to the mix and check to see if it's 0 or "", but, I still end up with the dreaded #Value! error message if column AO11 has no data. I've been working on other issues and coming back to this one and cannot for the life of me see where I doing something wrong or missing something! Can some one with clearer vision take a look at this formula and explain to me what I've missed

=IF(AH11+AI11=0,"",IF(V11+W11=0," ",IF(AO11=0," ",(((AH11+AI11)-(V11+W11))*24*60)-AO11))

Thanks,...
 
AO11 probably is not blank but contains a text (a space maybe)? ...
Click to expand...

The simplest way to deal with this may be

=IF(AH11+AI11=0,"",IF(V11+W11=0,"",IF(N(AO11)=0,"",
(((AH11+AI11)-(V11+W11))*24*60)-AO11)))
 
Maybe *I'm* missing somethimg, BUT ... I plugged your formula into a test
sheet and ... EVERYTHING works fine ... NO errors!

Are you *sure* you posted your formula *exactly* as it's in your sheet?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Harlan:

Thanks, for your input too. However, I am going to be doing an import into
Ms Access and need to have the "" empty string symbols be " ", otherwise,
I"ll end up with errors at that level too.

Any additional suggestions or ideas in addition to the one above will be
appreciated. You see, I would like to resolve this #Value! error at the
Excel level and avoid completely creating another in the other (Ms Access)
phase of this project!

Thanks, again for any assistance given........
 
Back
Top