Adjust IF Formula

[YOUNAN]

Hello,

I need some help with this Formula,

=IF(YEAR(U4)<=2014,B36*400+C36*200,0).

i need to adjust it so that it will check not only Year in cell U4 but also cells V4, W4 & Y4 and do the calculation (B36*400+C36*200,0)).


Thanks in advance.

Best Regards.

Younan

 

[YOUNAN]

Hello Again

I enter date in YYYY format, but the cells format is Number with no decimals, as said before, the formula you provided works with U column but not V,W & Y.

thanks for your help.

Best Regards

 

[Fluff]

Do you mean you are just entering the year in V,W & Y - ie 2014
or are you entering a proper date such as 1/1/2014

 

[YOUNAN]

Hello again

i am entering date to test the formula, such as 2017, 2016, and so on but the cell is format is number.

Best regards

 

[Fluff]

2017 is not a date it's a number.
If you are just entering 4 digit numbers into those cells try
=IF(AND(YEAR(U4)<=2014,V4<=2014,W4<=2014,Y4<=2014),B36*400+C36*200,0)

 

[YOUNAN]

Hello,

Its not working as i want , you can download the file from this link.

https://wetransfer.com/downloads/c7...76aef5195d019cedb784534620190314201943/2ab372

thanks for your time and patience.

Best regards

 

[Fluff]

Can you please re-supply the file with the values you are inputting for U,V,W & Y
Also which cell is the formula in?

 

[YOUNAN]

Hello,
You need just to look in sheet which has name 1, the formula i am after should be placed in cell H17.
Row 17 is for Year 2014, Row 18 for year 2015 and so on till year 2026.
in Row 4 cells U, V, W, Y the formula in H17 should work and count if they empty or date in these cells is less than 2014.
in row 5 cells U, V, W, Y the formula in H17 should work and count if they empty or date in these cells is less than 2014.
and so on.

hope this will help.

Best regards

 

[Fluff]

I cannot tell why the formula is not working for you, unless I know what EXACTLY you are entering into those cells.

 

[YOUNAN]

Hello,

Please check the files i sent in following link, it contains pictures, word file with explanations and the excel file i am working on.

https://wetransfer.com/downloads/72...c3e94087d1c3e6d88a4c467420190315181554/563a82


thanks in advance.

Best regards

 

[Fluff]

It would have a lot easier (for both of us) if you had done as I requested. That is, to re-supply the file with some actual values in the cells, rather than entering a value taking a picture, entering another value & taking another picture.

How about
=IF(AND(U4<=2014,V4<=2014,W4<=2014,Y4<=2014),B36*400+C36*200,0)