Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top


  • E13 is a YES or NO,

  • E14 is a number,

  • L21 is a currency amount equal to E14*1 BUT;

    • If cell E13 is YES, then cell L21 cannot be any higher than $80.00;

    • If cell E13 is NO, then cell L21 cannot be any higher than $40.00.

share|improve this question
Welcome to SuperUser! Please add more detail to clarify your question. In its current form it may be deleted. – user3463 Oct 3 '13 at 19:10
@RandolphWest The question seems pretty straightforward. What other details are necessary? – John Bensin Oct 3 '13 at 19:32
Jerry's edit would be what I was getting at. – user3463 Oct 3 '13 at 21:36

If E13 can only be Yes or No, you can use this:


If E13 is Yes, get the lower of E14 and 80, otherwise, the lower of E14 and 40.

share|improve this answer


Might not be elegant, e.g. doesn't discriminate between "no" and not "yes", but it works.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.