Question: I need help figuring out the exact formula to enter into: FORMULA - LOGICAL: IF ( in cell E5), FUNCTION ARGUMENT IF: Logical test (?),

I need help figuring out the exact formula to enter into: FORMULA - LOGICAL: IF ( in cell E5), "FUNCTION ARGUMENT" IF: Logical test (?), Value_if_true (?), and Value_if_false (?).... The formula from above is not the correct formula of use. HELP ME PLEASE, WITH THE CORRECT FORMULA TO INPUT INTO THE "FUNCTION ARGUMENT" Box!........

I need help figuring out the exact formula to enter into: FORMULA

IFO) Dodson Jones Clarke Ranger McKinle Broadnax Burch Totals Silver$400.00 Yes Gold Titanium $700.00 No Platinum $750.00 No Platinum $750.00 Yes Gold Titanium $700.00 Yes $550.00 Yes 2 $550.00 No 2 Function Arguments IF Ring T Silver Gold Titanium Platinum Cost $ 400.00 $550.00 $ 700.00 750.00 Logical_test | Value if true Value if false logical any any Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. Personalizing Surcharge Interest Rate Logical test is any value or expression that can be evaluated to TRUE or FALSE. 5% 3% Formula result = ClassRing Help on this function OK Cancel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!