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

Question

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!........  

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

Explanation / Answer

Hi,

please find the below formula for IF condition in excel. I'm not able to paste the screenshot due to some problem. So, i'm writing it below.

The formula i used is if marks are greater than 60, result should be pass otherwise fail.

=IF(B2>=60,"Pass","fail")

In Functional Argument window. Below are the values should be given for above example

Logical_test = B2>=60

Value_if_true = "Pass"

Value_if_false = "fail"

Hope this clarifies your question.

A B Result AAA 89 Pass BB 67 Pass cc 50 fail dd 54 fail

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.