If function

Closed
Kye - Mar 6, 2021 at 10:48 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Mar 6, 2021 at 12:57 PM
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 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Mar 6, 2021 at 11:33 AM
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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Mar 6, 2021 at 12:57 PM
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