Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Cell:

  • 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
1  
@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
add comment

2 Answers

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

=IF(E13="Yes",MIN(E14,80),MIN(E14,40))

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

share|improve this answer
add comment

=IF(E13="yes",IF(E14>80,80,E14),IF(E14>40,40,E14))

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

share|improve this answer
add comment

Your Answer

 
discard

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.