Jobs & Education6 mins ago
Excel IF formula with two logical tests?
18 Answers
Hello...
Does anyopne know how I can say 'if A1 says 'Yes' AND B1 says 100, then the value if true will be 'Incorrect', value if false will be 'Correct'?
I know about 'IF', but not sure how to work it out if I have two cells I want to look at (the logical test bit)? One assumes I need to use the & function?
Thanks!
Does anyopne know how I can say 'if A1 says 'Yes' AND B1 says 100, then the value if true will be 'Incorrect', value if false will be 'Correct'?
I know about 'IF', but not sure how to work it out if I have two cells I want to look at (the logical test bit)? One assumes I need to use the & function?
Thanks!
Answers
Best Answer
No best answer has yet been selected by funkylad20. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.OK, thanks. It worked for a bit, then stopped...I may have to use the actuals to see if any of you can help...
I have the following formula:
=IF(AND(E51=$E$3, G51<50001),"Eligible","Ineligible")
E51 is either type 'Statutory' or 'Non-Statutory'. G51 is the value of money.
If the value of money is OVER £50,000 and it is also Statutory, then the result should be 'Eligible'. If the type is 'Non-Statutory', then it should be 'Ineligible'.
as I say, the foruma you ahve worked and I have applied into my scenario works to an extent, but then for some it doesn't...?
I have the following formula:
=IF(AND(E51=$E$3, G51<50001),"Eligible","Ineligible")
E51 is either type 'Statutory' or 'Non-Statutory'. G51 is the value of money.
If the value of money is OVER £50,000 and it is also Statutory, then the result should be 'Eligible'. If the type is 'Non-Statutory', then it should be 'Ineligible'.
as I say, the foruma you ahve worked and I have applied into my scenario works to an extent, but then for some it doesn't...?
Oh I fix it because I use a drop down, drawing from E2 and E3. E3 is 'Non-statutory' and E2 is 'Statutory'.
This formula works for 'Non-statutory' and less than £50,000, BUT when I hit a line that is 'Statutory' and the value is £63,000, it says 'ineligible' (the threshold for 'Statutory' is up to £150,000 before it becomes ineligible....)
This formula works for 'Non-statutory' and less than £50,000, BUT when I hit a line that is 'Statutory' and the value is £63,000, it says 'ineligible' (the threshold for 'Statutory' is up to £150,000 before it becomes ineligible....)
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.