Take the 2-minute tour ×
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
    
I have no answers to this, but I think some of the question isn't localised correctly. I suspect 'isempty' in your title and question should be ISBLANK, WENN should be IF (?), and UND should be AND. Perhaps try making those changes (if you agree?), then perhaps the question will get more attention? –  Ashley May 20 '13 at 17:35

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.