Document Link: https://drive.google.com/open?id=0B_lD7FHorWGzcEpjeGhGN3FzeEU

> is used in place of the greater than symbol since it’s an illegal character for video descriptions.

Formulas:

=A2:A6+B2:B6

=VLOOKUP(E10,modifiers,2)

=IF(A10>89,”A”,IF(A10>79,”B”,IF(A10>69,”C”,IF(A10>59,”D”,”F”))))

Check out the NEW WEBSITE: https://growyourcareer.com

UPDATED BLOG: https://arcologydesigns.blogspot.com

Arrays are used to create formulas that affect a group of cells. Note that Excel…

Check out the NEW WEBSITE: https://growyourcareer.com

UPDATED BLOG: https://arcologydesigns.blogspot.com

Cool. Helpful. Sorted a vlookup for a range of > values to return a £ amount. Made my life easier 🙂

How do you select from a list based on another cell? IE. B1 IF A1(data list of 1-9) is a number between 1-9, If it is 1 then select from data list C1-C9, if 2 then select from data list D1-D9, etc.

I know it is an old post but has helped in 2016. Thanks, man. Your time and work are highly appreciated.

if i have 10 cells, numbered 1 to 10, and deleted number 9, how can deleted value return a given cell, say c15?

Well executed………

@salma ibrahim

There is no "Reply" button on your comment for some reason.

In regards to your question, F4 is a hotkey (a shortcut) that allows you to switch between absolute and relative cell reference. Absolute means the cell value will not change if you copy and paste the formula. Relative means it will change. For example, if you use relative (without a $ sign) reference and paste the formula one row below, the relative reference will increase by one row. It depends on whether you need to use a constant or a dynamically changing cell.

The comma is used to separate arguments in a function, the equals is used to evaluate a boolean expression. Thus IF(B1="Blue","Correct","Wrong") means if cell B1 holds the value blue, it is correct; if it is any other color it is wrong. I hope that helps.

Thank you very much !

i really appreciate , but i want to ask a question: What is the purpose of the F4 button , in many functions, which is the absolute reference?

Another thing please, i want to know when to put = in front of the criteria in the if function and when to put a comma

for example : ="C" and sometimes it is written ,"C"

actually i am taking ICT this session in cie which is going to be next month , so i need a quick respond , please.

can you suggest me procedures or help , when a hard question meet me in solving excel ?

Hey man! Could please not speak to fast.

Hi, I have been searching through excel for help with a nested if and vlookup function and haven't been successful. I was hoping you could help. I have a table that I must use a nested if and vlookup formula in order to get my results using both vertical and horizontal cells. I understand nested if formula and vlookup formulas but not able to get them to work together in the same formula using both horizontal and vertical cells. Any suggestions?

Is it just me,, or did you purposely exclude the grade of 50? Coz it complicates the formula?

Is it just me,, or did you purposely exclude the grade of 50? Coz it complicates the formula?

Thanks, happy it helped! 😀

Very informative. It helped a lot. Thanks.