Forum Discussion
Help with formula for more than one condition
I've created a spreadsheet where scores are inputted. I've totalled that in one cell and converted this to a grade in another cell using a formula. The problem I've got is that some cells are more important so if they're not achieved the grade given needs to be one lower than the one given using the formula.
I've been trying to create a formula that allows for this. I can't make one that allows for all the different grade options: this works for one level but when I try to add to it, it no longer works. I need it to work for five different levels and change the grade if the value is less than 6.
=IF(D25="3DEV",D26<=6,"3EM")
Thank you for your help!
I've been trying to create a formula that allows for this. I can't make one that allows for all the different grade options: this works for one level but when I try to add to it, it no longer works. I need it to work for five different levels and change the grade if the value is less than 6.
=IF(D25="3DEV",D26<=6,"3EM")
Thank you for your help!
8 Replies
Perhaps you may provide small sample file with manually added desired result, so far it's not very clear what is required.
SergeiBaklan Thanks. I've added this spreadsheet with the correct result in the bottom cells. I hope this makes more sense.
Thanks
Nothing wrong with formula in cell B24 & C24. Also formula in B26 working properly,, you have not dragged the formula in C26, otherwise in both cells you get 3 BEG,,, now let me say I'm unable to realize what exactly you are looking for,, please be specific all about the issue.
