Advanced Excel - Using the IF Function in Excel to Program Your Spreadsheets
video description
Date: 2022-04-08
Related videos
Comments and reviews: 8
Marquita
Hello I need some assist. I have a workbook with several worksheets which requires the response to read -correct- or -NA- or -incorrect-. I need for the various rows to calculate the number of -corrects- on a specific cell on the various sheets within the workbook. please assist with a formula.
reply
Hello I need some assist. I have a workbook with several worksheets which requires the response to read -correct- or -NA- or -incorrect-. I need for the various rows to calculate the number of -corrects- on a specific cell on the various sheets within the workbook. please assist with a formula.
reply
clyde
So when making If statements, can you have the statement correlate to a tolerance? If you have a measurement tolerance of 2- to 2.5- how can you make anything in that tolerance, say for this instance a -Pass- and anything greater or less than that tolerance a -Fail-?
reply
So when making If statements, can you have the statement correlate to a tolerance? If you have a measurement tolerance of 2- to 2.5- how can you make anything in that tolerance, say for this instance a -Pass- and anything greater or less than that tolerance a -Fail-?
reply
Cris
I'd like to ask what if a specific cell contains a name or letter and you need to it to appear in another cell
For example: all first name that starts with letter -C- - how am I going to make the name appears in another cell that contains or starts with letter C?
reply
I'd like to ask what if a specific cell contains a name or letter and you need to it to appear in another cell
For example: all first name that starts with letter -C- - how am I going to make the name appears in another cell that contains or starts with letter C?
reply
Evil
I don,t know why people give unlike to a complete, easily explained tutorial, having just a cost of watching only. I am thinking, if I am not wrong, they are just jealous from you in some sense. Thank you so much respected teacher, your videos are amazing.
reply
I don,t know why people give unlike to a complete, easily explained tutorial, having just a cost of watching only. I am thinking, if I am not wrong, they are just jealous from you in some sense. Thank you so much respected teacher, your videos are amazing.
reply
Raasha
I so enjoy learning from your tutorials. Does anyone know what needs to be done if it's not just -pass- or -fail-? What if I have verbal raw data and I need to score them numerically with multiple possible results?
reply
I so enjoy learning from your tutorials. Does anyone know what needs to be done if it's not just -pass- or -fail-? What if I have verbal raw data and I need to score them numerically with multiple possible results?
reply
BILL
Reading the comments below I couldn't agree more, they have accurately described your delivery.
Looking forward to seeing more of your tutorials, thank you great job
reply
Reading the comments below I couldn't agree more, they have accurately described your delivery.
Looking forward to seeing more of your tutorials, thank you great job
reply
MPrime17
Honestly, I found your teaching so easy to understand and welcoming. Your voice, too. U can run your own podcast with that beauty haha
reply
Honestly, I found your teaching so easy to understand and welcoming. Your voice, too. U can run your own podcast with that beauty haha
reply
RASPUTIN
can this function or something similar be used to format the colour of the cell? E.G. Pass = Green fill and Fail = Red fill?
reply
can this function or something similar be used to format the colour of the cell? E.G. Pass = Green fill and Fail = Red fill?
reply
Add a review, comment
Other channel videos
