IF and AND formula

[hyruleramone]

Hello,

I need to build a formula that can tell me that if my salary rank is 2 then i get 2% bonus, but if I work at night I get 1% extra bonus. The way I know i work at night is because there is a column that says N -->

Salary Rank Salary Work At Night
2% 200 N

math should be: (0.02 + 0.01) * $200 = $6

how can i accomplish this with IF and AND?

Could it be something like: =IF(AND(B2=2,"3%")=N,+"1%")*C2

Thanks.

 

[mumps]

Assuming the data is in A1:C1, place this formula in D1: =IF(C1="N",(0.02+0.01)*B1,0.02*B1)

 

[hyruleramone]

Assuming the data is in A1:C1, place this formula in D1: =IF(C1="N",(0.02+0.01)*B1,0.02*B1)

Thanks for the answer.

I am doing a homework and the teacher put me to practice IF and AND, so how can I add do it with IF(AND....?

is there a way?

 

[mumps]

Forum members can offer guidance but they don't normally do your homework assignment for you. Have a look at this link: https://exceljet.net/formula/if-this-and-that