Question

Hi does anyone know how to do functions in Excel? Im doing something that is due in 2 hours and have no idea how to work the function...

Answer 1

this is what I need but have no idea, I need to use an IF function, even if you show me how to do it without using these exact numbers. Question:

4. In cell G2, create a formula using the IF function and structured references to create a calculated column that determines the value of Weeks Vacation based on the following criteria:
a. If the years employed are less than 3, the Weeks Vacation should be 2
b. If the years employed are 3 or more, the Weeks Vacation should be 3

Answer 2

Let's say you had data in cells A1 through A7

if you want to sum up the cells without having to do A1+A2+...+A7, you can use the `sum` function

type `=sum(A1:A7)` in any other cell and then hit enter

Answer 3

the equal sign in front of the "sum" is not a typo. It's how you tell excel that you're not just typing in text. It's a signal to tell excel to treat it like a function

Answer 4

yea, I know a few of the basic ones, just with these numbers I don't know what to put in the three boxes, Logical_test, Value_if_true, and Value_if_false

Answer 5

https://support.office.com/en-us/article/IF-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2

the IF function evaluates a statement and there are 2 outcomes

* The statement is true ---> instruction1 is executed
* The statement is false ---> instruction2 is executed

Only one of the instructions can be executed since the statement can't be both true and false at the same time

Answer 6

so I would put in the numbers/cells for a in Value_if_true and b in false?

Answer 7

on that link, they have this example

`=IF(A2>B2,"Over Budget","OK")`

so here's how the function works

the program looks at A2 and compares it to B2. The numbers in each cell
it asks "is A2 larger than B2?"

If that question is true, then the instruction "print 'over budget'" is executed. Basically the cell where this IF statement is typed changes to "over budget"

Answer 8

if A2 > B2 is false, then "Ok" is printed

Answer 9

ok and so for the one they showed, =IF(A2>B2,"Over Budget","OK")
it goes like this with logic, true then false values?
=IF(A2>B2,
"Over Budget",
"OK")