Excel Help

[Dylan Power]

I am doing a spreadsheet and i need to use a formula for displaying this is what i got 

 

=IF(D2>10,"Good") or IF(d2<10,"Bad")

 

But it says it wrong PLEASE HELP !

[79wjd]

Depending on how you want to handle equivalence.

 

=IF(D2 > 10, "Good", "Bad")

=IF(D2 > 10, "Good", IF(D2 < 10, "Bad", ""))

[minibois]

Looks like it should be done in this way:

=IF((OR(D2 > 10, D2 <= 10)), "Good", "Bad")

Although I was only able to test it out with Google Spreadsheets. Worked in there though.

 

P.S. I changed the formula a bit, from greater or lesser than 10, to greater than 10, or lesser/equal to 10. Without that equal to in the formula, you're excluding all the entries of exactly 10 from your formula (although you may want to use that, depends on what you want to do).

[Dylan Power]

THANKS EVERYONE SO MUCH!

 

 

ps how would i also make it say "Great" 

[minibois]

22 hours ago, Dylan Power said:

THANKS EVERYONE SO MUCH!

 

 

ps how would i also make it say "Great" 

Be sure to quote people when replying, otherwise we wont see your additional questions.

 

 

I just spent an hour trying to do this formula, Excel was not cooporating (giving me weird errors on what looked like a good formula) I just pasted it in Google Spreadsheets and it just worked.

 

I got the formula here, but I am not about to try and make it work with Excel's seemingly subpar formula system.

=IF(B2 = 10,"Perfect!", IF(OR(B2 >= 6, "Good", "Bad")))

If you have a 10, you get Perfect. If your grade is above 6 (but not 10) you get Good. Otherwise you get bad.

Example:

 

Excel for some reason doesn't want to just run this formula, not sure why to be honest.

 

P.S. You can of course change the numbers around however you like.

I also checked a lot of website for sources, this one seems to be the closest to what you need:

https://www.ablebits.com/office-addins-blog/2014/12/03/excel-if-function-iferrror-ifna/comment-page-8/

 

EDIT:

I forgot to mention, this formula needs to be listed in all the cells you want it to work in. The way I did it is explained here: 

https://www.ablebits.com/office-addins-blog/2016/01/20/copy-formula-excel/

That way the 'references' also change (B2 becomes B3 in the cell below, etc.)

[LogicalDrm]

10 hours ago, Minibois said:

Excel for some reason doesn't want to just run this formula, not sure why to be honest. 

Could it be all of spaces used? Maybe. Not on Excel until Monday so can't check.

[minibois]

13 minutes ago, LogicalDrm said:

Could it be all of spaces used? Maybe. Not on Excel until Monday so can't check.

I just tried copy-pasting (this working in Spreadsheets) formula into Excel, removed all spaces and it still doesn't work.

Perhaps it's just my unfamiliarity with Excel, but this is basically what goes wrong:

It kind of 'clumps together' the entire formula into the logical test space. I tried manually fixing it, but when trying to implement the first nested IF it all goes wrong. It's probably an easy fix someone with actual Excel skill can fix, but I quite frankly just found Excel to be way too clunky this morning to bother with it any more.

[LogicalDrm]

7 hours ago, Minibois said:

I just tried copy-pasting (this working in Spreadsheets) formula into Excel, removed all spaces and it still doesn't work.

Perhaps it's just my unfamiliarity with Excel, but this is basically what goes wrong:

It kind of 'clumps together' the entire formula into the logical test space. I tried manually fixing it, but when trying to implement the first nested IF it all goes wrong. It's probably an easy fix someone with actual Excel skill can fix, but I quite frankly just found Excel to be way too clunky this morning to bother with it any more.

Ok, the other one I can think is (OR( part of it. I think that's unnecessary. Nesting IF functions should already cover whatever that's supposed to be doing.