If function

Report
-
Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
-
Hello,


I have done this function but it keeps saying false and that the formula is wrong even though I did what you suggested by using semi colons I did everything

Here's what it looks like

=IF(B2>=75;"distinction";J17=IF(B2>=50;"pass";"fail"))

3 replies

Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
144
Kye, Good morning.

The message is correct!

Pay attention:
You have 2 formulas inside 1.

=IF(B2>=75 ;"distinction"; J17 = IF(B2>=50; "pass"; "fail"))

What means this J17= in your formula?

If you cut it off, your formula will works perfectly.

Please, tell us your neceesity and we will be able to help you.
What do you mean I have 2 formulas in one that's how we're supposed to do it or not and how Co I cut it off
I have realized that J17 was the cell I selected by mistake instead of the correct one so I went back and corrected it and the error message kept constantly showing
Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
144
Kye,

"...What means this J17= in your formula? ..."

You need to cut off 17= from your formula.

Correct formula: =IF(B2>=75 ;"distinction"; IF(B2>=50; "pass"; "fail"))

I hope it helps

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!