IF, AND, OR - Looking for Round Apples

IF, AND, OR

More practice with the IF, AND, OR logic formula. I used the IF and OR to identify certain colored apples and mark an x if so. I used the IF & AND to determine if it is a round apple or not.

Comments

Post a Comment

Popular posts from this blog

Ranking of UC Schools from Top 110 Ranked National Universities of 2024

Link to GitHub:  https://github.com/sgng-hub/2024unviersityranking Link to Dataset: https://www.kaggle.com/datasets/raymondtoo/the-world-university-rankings-2016-2024 Dataset Official Source: https://www.timeshighereducation.com/world-university-rankings/2024/world-ranking This project is about writing SQL query to find the ranking of top 110 world universities that are part of the University of California System I included a link to Looker Studio visualization of the query     
Read more

Remove Duplicates

Image
One Way to do this is to use the UNIQUE funciton, which is what I often use. For example, I have several vendor codes for different invoice number. Use the Unique function and it will remove all duplicates and give you only the unique vendor codes. This is helpful when I do entry in the accounting software, especially when there is over 500+ lines of vendor codes. Alternatively, you can use ALT + A + M to remove duplicates, so definitely will start using that more!
Read more

Hlookup & Right

Image
HLOOKUP Per the website, "HLOOKUP stands for Horizontal Lookup and can be used to retrieve information from a table by searching a row for the matching data and outputting from the corresponding column. While VLOOKUP searches for the value in a column, HLOOKUP searches for the value in a row." Below, I wanted to return the number of Basis invoices paid on week 1, week 2, week 3, etc. I used the right formula here because the row index number is always one more than the week. Alternatively, on another sheet, I also just used an array constant that allowed me to use just one single formula to output the same result.
Read more