We will assume that your number 'n' resides in cell B1. Can you help?Īnswer:You can create this formula using nested IF functions. I realise it's probably an 'IF(AND)' function but I appear to require too many arguments.

If A2 = 63, the formula will return 1 (third IF function) If A2 = 80, the formula will return 2 (second IF function) If A2 >= 95, the formula will return 3 (first IF function) Question:I have read your piece on nested IFs in Excel, but I still cannot work out what is wrong with my formula please could you help? Here is what I have: =IF(6395,3,0)))Īnswer: The simplest way to write your nested IF statement based on the logic you describe above is: =IF(A2>=95,3,IF(A2>=80,2,IF(A2>=63,1,0))) Can you help me with the IF function on this one?Īnswer: You can write a nested IF statement that uses the AND function and the ISBLANK function as follows: =IF(AND(ISBLANK(A2)=FALSE,A2>=0),C1+A2, IF(AND(ISBLANK(B2)=FALSE,B2>=0),C1-B2, IF(AND(ISBLANK(A2)=TRUE, ISBLANK(B2)=TRUE),C1,''))) If both A2 and B2 are blank then equals C1. If cell B2 is greater than or equal to 0 then subtract from C1. If cell A2 is greater than or equal to 0 then add to C1. For example: =IF(A1 4 but 9 but 15, return $75Īnswer:In cell C5, you can write a nested IF statement that uses the AND function as follows: =IF((A1+B1)4,(A1+B1)9,(A1+B1)1,000,000 then A1*.01% but maximum 5000Īnswer: You can write a nested IF statement that uses the MAX function and the MIN function as follows: =IF(A11000000,MIN(5000,A1*0.01%),'')) If its is greater than or equal to 50 and less than 100, then multiply by 3Īnd if it is great or equal to than 100, then multiply by 4Īnswer: You can write a nested IF statement to handle this.

If it is greater than or equal to 20 but less than 50, then multiply by 2 If (cell A1) is less than 20, then multiply by 1, Question: In Microsoft Excel, I need to write a formula that works this way:

How to apply if then formula in excel