If Formula with Dropdown conditions
I am trying to get an IF statement to check conditions of 3 dropdowns and based on those being true either add a specific value or do a calculation. Below is what I am trying, but I am only getting it to populate N/A, no matter what the values entered are. If the 3 that are entered below are true it should enter the value of $467.00.
=IF([Visit Type]1 = "Temp Staff Aug", IF([Site Name and Number]1 = "Amgen France", IF([Sell Price]1 = [Sell Price]1 = "Engineer Day Rate", "$467.00", "N/A")))
Comments
-
I think you will need to use IF(AND or IF(OR
=IF(AND(AND_expression1, AND_expression2, AND_expression3)IF_logical ecpression, value_if_True, value_if_false)
=IF(AND([Visit Type]1 = "Temp Staff Aug", [Site Name and Number]1 = "Amgen France", [Sell Price]1 = "Sell Price", [Engineer Day Rate]1 = 467), 467, 0)
the formula is in a result column, Results Column
-
Thank you, I will try it out
-
I just update my post I tested it and it seem to work.
-
I think you nailed it, thanks again
-
If that doesn't work, try taking out the 2nd IF statement.
=IF(expression1, expression2, expression3), value_if_True, value_if_false)
-
Still getting an unparseable error, I included a screenshot below.
Here is formula, I am missing something...
=IF(AND_([Visit Type]1 = "Temp Staff Aug", [Site Name and Number]1 = "Amgen France",[Sell Price]1 = "Engineer Day Rate",[Column11]1 = 467), 467, 0)
-
That did it! Thanks!
-
Sure thing. Happy to help.
-
May I also jump in on this topic...Paul Newcome can you help me with a child-parent dropdown formula? For QA testing, I want the parent to reflect the condition of any child. So if the child passes a test, the parent passes. But any fail for a child supersedes the pass of any child and fails the parent. See attached...appreciate the help!
-
An addendum to my query above, which isn't actually above yet...I'm halfway there with this:
=IF(COUNTIF(CHILDREN(), "Pass") > 0, "Pass", IF(COUNTIF(CHILDREN(), "Fail") > 0, "Fail"))
But I need "Fail" to supersede "Pass." Help??
-
Formulas read left to right, so if you just swap the order of the IF's, then you should be good to go...
=IF(COUNTIF(CHILDREN(), "Fail") > 0, "Fail", IF(COUNTIF(CHILDREN(), "Pass") > 0, "Pass"))
-
Thanks, Paul. Yes, figured that out (the order). Working like a charm now.
Cheers,
Suzanne
-
-
Hi Paul...Can we have IF statement to pick Contact (only one that I have) from drop down list?
Help Article Resources
Categories
Check out the Formula Handbook template!
