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 imp...
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.
- C26 and B26 need to give different results even though they have the same score as B6 and B7 have to have at least 3 points in each (can have a total of 4points in each). I was asked to add manually what result I wanted so in C26 I need "3 EM". I need a longer formula than the successful one in B26 as there are five grades which need to be lowered by one grade if the total of B6 and B7 (which is in B25) is less than 6. Whenever I try to add more conditions the cell comes back with true or error. I need a formula to change the grade to one below if the total of B25 is less than 6. Hope this makes it clear. Thanks
- I think,, being a OP (original post owner) one must have upload proper data with illustration all about the exact need,,, coz as answerer ,,, we pick from the shared data,, assumption sometimes back fires. ☺
I'd suggest to add helper range in any place of your workbook as
with it formula could be
=LOOKUP(SUM(B$5:B$22),$G$7:$G$12,CHOOSE(((B$5+B$6)>=6)+1,$H$6:$H$11,$H$7:$H$12))which returns
- Brilliant thank you so much!
