Tell me more ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

I've got a list of times and ages, and want to extract ages for a particular range of time values. So I've used an 'if' formula to copy the age for an entry if its time is between two values. The problem is the value for entries outside that time range. I'd like value to be 'empty' or 'null'. I've tried including no argument in the 'if' formula and also and empty string (""). A check with 'isempty' returns true. For example:

=WENN(UND($D>=F$1;$D<G$1);$C;)
=WENN(UND($D>=F$1;$D<G$1);$C;"")

both of these produce values that aren't 'empty'.

share|improve this question

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.