Start the formula with the condition of >=90 and then >=80 and so on then you will fell the difference because you will not need to write the < (less than) part of the formula Use this formula instead =if(cell>=90,"Golden A+",if(cell>=80,"A+",if(cell>=70,"A",if(cell>=60,"B",if(cell>=50,"C",if(cell>=40,"D","F")))))) Don't forget to change "cell" with the actual cell name
Please answer me I wrote a formula for students' mark sheets is right or wrong. =IF(AnD(C2>=33,D2>=33,E2>=33),''Pas'',''Fail''). Please 🙏 answer me. It shows error .
I would like to provide a feedback. First you need to speak properly what you are trying to say. Other's are excellent but the way of explaining it's totally you know......
*Swift Learn* Perfect as always. Have a superior day :p
Thanks for your comment.
@@SwiftLearn Can you give the formula in text, i just want to copy it instead, its so long
Awesome training. Thank you so much 🎉
You're so welcome! please keep connected!!
Start the formula with the condition of >=90 and then >=80 and so on then you will fell the difference because you will not need to write the < (less than) part of the formula
Use this formula instead
=if(cell>=90,"Golden A+",if(cell>=80,"A+",if(cell>=70,"A",if(cell>=60,"B",if(cell>=50,"C",if(cell>=40,"D","F"))))))
Don't forget to change "cell" with the actual cell name
Great 👍👍. Thanks.
@@bukhtawernaeem7566 bro thank u so much for this formula 👍
It is very useful. Thank you very much
Glad it was helpful! You are very kind. Please keep connected.
Worked like a charm.
Thank you so much for your help.
Thanks for your valuable comments.
Nice. Please upload a basic knowledge of microsoft office
Thanks for your comment
Just what i was looking for. Thank you so much
using *IFS()* is much clean and convenient than *IF()* for multiple conditions scenario
Very helpful tutorial. please upload a complete concept of excel. thanks
Will upload soon
Hurrah! Exactly what I want. You save My Time one Day Because Of This Formula . Thank You.
You just confused me even more, thank you
Oppssss. Thanks for your comment
Thanks a lot …very work full method
This is exactly what I want. thanks
Thanks for your comment. please keep connected
Thanks I found this easy to understand and I was able to get my formula to work.
thankyou. found exactly what i wanted :>
[which is using likert range]
have a good day, sir!
great content
NICE AND THANKS SIR
Please post more videos related to excel and other office tools
Excellent formula.
Thank for this😊
Thanks for your valuable comments.
GREAT WORK
It's really helpful ...
Nice tutorial. as expected.
Thank you ☺🙏🏻
Excellent
Thank you so much 😀
Thank you so much
You're welcome! Please keep connected.
Thanks
If I want to add Color, for example golden A+ as green and F as red in grade column. How can we do it.
Nice idea. I didn't think it yet. Will make such tutorial very soon. Thanks 👍
It is informative, but the accent is hard to catch. 😞
Turn on cc
This will be the answer
thanx
For the last condition which is 90 and above, why the condition is not kept within the bracket?
Please answer me I wrote a formula for students' mark sheets is right or wrong. =IF(AnD(C2>=33,D2>=33,E2>=33),''Pas'',''Fail''). Please 🙏 answer me. It shows error .
Put inverted commas as in the video
Can I count p=1,s=2,H=1/2 in one cell
How can I add 3 marks in diferent colums
Varience is not negative
You are showing the Standard in wrong way by using ">" sign.
Help me debug the error please ..... =IF((AND(C6=100),"Excellent"))))
Varience is not negative
Fiftli foultli kulu kili kulu kulu kili kili, twentlei
And me also
Subscribe🎉
Please😊
O BHAI PEHLAY KHUD TU SEEKH LAT TERI MEHARBANI HUMAY JO AATA HAI WO B BHOOL JAIN GAIN HUM
what is tharti five😂😂
You are very confused 😕
Sorry. Try to better.
I would like to provide a feedback.
First you need to speak properly what you are trying to say. Other's are excellent but the way of explaining it's totally you know......
It too long, I have easy formula.......
Where is the If Else ?
We don't use the word else in this formula but it is called if else because we have two options on the basis of one condition
THIS IS NOT HELPFUL, I DON'T UNDERSTAND EVERYTHING
I can't hear anything thorugh that accent
Turn on cc
Slow
Thanks
Excellent
Thank you so much 😀