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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Mar 6, 2021 at 12:57 PM
Related:
- If function
- Find function on mac - Guide
- Agp function - Guide
- Spreadsheet function - Guide
- Accessor function c++ - Guide
- Hard drive function - Guide
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
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.
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.
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
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
"...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
Mar 6, 2021 at 11:49 AM