Ask Experts Questions for FREE Help !
Ask
    mcdonf's Avatar
    mcdonf Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jan 21, 2009, 11:58 AM
    tricky formula
    I want to create a formual that will multiply two cells. Now there need to be a couple of criteria to fulfill this formula. First one cells (c1) value is always 100 the other (c2) will be 60-inputed value. Now C2 must be less than 60 ( c2<60) and finally the value must not exceed 1000. So in otherwords every number below 60 and at or above 50 will be multiplied by 100
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Jan 22, 2009, 12:55 AM

    Well, this is the formula that follows your logic, but you said the result couldn't be higher than 1000, and EVERY number between 50 and 60 multiplied by 100 is more than 1000.

    Anyway:

    =IF(AND(C2>=50,C2<60),C1*C2,"Invalid")
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

What to do when things get tricky [ 6 Answers ]

My husband wants to adopt my three boys. I have not yet started the paperwork only because I haven't been able to find any reasonable help. We would like to do the paperwork ourselves or as much as we can anyway. But would like some advice about the process. I know the basics, but our situation is...

Here's a tricky [ 3 Answers ]

o.k so I am trying to get preggy sense end of dec. 2006 3 months , so I have gained some weight recently has noyhing to do with pregnancy , but could that hurt me getting pregnant , also what do you think about women's one a day vitamin , seeing I am 24 do you think it helps you concive , I am...

Tricky F1-OPT SS Tax Question [ 9 Answers ]

Hi Tax experts, I have a question regarding Social Security and Medicare Tax during F1-OPT . July 2000 - Dec 2002 - F1 Visa Jan 2003 - Dec 2003 - OPT Jan 2004 - Present - H1B Visa My employer deducted Social Security and Medicare taxes during my OPT period.In Nov 2006 ,I found that I...

Tricky Tax Situation [ 10 Answers ]

Hi, my basic information is as follows, 1. Married (My spouse is H1B status and resident alien) 2. Currently OPT (expired next February) and non resident alien (F1) So far, I had no income in the US except for small interests in bank accounts 3. Going to enter into contract as...

View more questions Search