Excel with Conditional Formula per month

Asked

Viewed 62 times

3

I have this formula in the calculation column in the table: =+(K5+L5)*(1+8%) working!

I changed the conditional calculation per month, example: =IF(MONTH(A4)>=10,(+(K4+L4)*(1+10%)),(+(K4+L4)*(1+8%))) worked!

Question:

How to use AND correctly?

=IF((MONTH(A4)<=2) AND (MONTH(A4)>=10) ,(+(K4+L4)*(1+10%)),(+(K4+L4)*(1+8%)))

Note. The date in cell A4 is in this format:

Year/Month/Day - 2019/02/04

excel fórmula

  • Thus: IF(AND(MONTH(A4)<=2,MONTH(A4)>=10)...

1 answer

4


Its formula contains some wrong things, for example those + loose in the formula and the wrong use of and.

To use a and or or correctly you have to put them at the beginning of the function they will concatenate, in your case soon after the if. Would look like this:

=IF(AND(MONTH(A4)<=2,MONTH(A4)>=10),(K4+L4)*(1+10%),(K4+L4)*(1+8%))

Check out an excellent tutorial on the subject clicking here.

  • I use Office 365 in English at work (where I tested the above formula) and Office 365 at home and in both use ;. But that can be changed. If you are interested, just follow this step by step https://www.officetooltips.com/office_2016/tips/change_the_semicolon_to_a_comma_or_vice_versa.html

  • Max and Ricardo, thanks. I put the formula, but it did not work in my Excel 2010 Japanese!

  • I changed the formula and it worked! Max and Ricardo formula: =IF(AND(MONTH(A4)<=2,MONTH(A4)>=10),(K4+L4)(1+10%),(K4+L4)(1+8%)) Changed. =IF(AND(MONTH(A4)>=4,MONTH(A4)<=10),(+(K4+L4)(1+10%)),(+(K4+L4)(1+8%))))# Solved! Moderator how to accept the answer in this case?

  • @soushinsha Leia how to accept an answer

Browser other questions tagged excel fórmula

You are not signed in. Login or sign up in order to post.