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

 

[Fluff]

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

 

[YOUNAN]

Thank you for your reply, i will test it when i get back home.
Just wondering if there is any other function ( Not IF Function Niether VBA ) to get the same result, asking just to increase my knowledge.

Thanks again

Best regards

 

[Fluff]

Very possibly, but formulae aren't my strong point, so cannot say for sure.

 

[YOUNAN]

Hi again,

thanks for all, I tried the formula, it works only for cell U4 not the for the other 3 cells V, W, Y.

Best regards

 

[Fluff]

In what way doesn't it work?

 

[YOUNAN]

Hello

This is what i get when entering the new Formula .

[h=1]We found a problem with this formula. Try clicking Insert Function on the Formulas tab to fix it, or click Help for more info on common formula problems. Not trying to type a formula? When the first character is an equal (=) or minus (-) sign, Excel thinks it's a formula: • you type: =1+1, cell shows: 2 To get around this, type an apostrophe ( ' ) first: • you type: '=1+1, cell shows: =1+1.[/h]
Thank you for your help.

Best Regards

 

[Fluff]

In that case you probably made a typo when entering the formula.
Just copy the formula & paste it into your sheet.

 

[YOUNAN]

Hello Again,
I copied and pasted the formula, no error message, but the sum works only the new formula works with cell U4, when entering a number greater than 2014 in cells V4, W4, Y4 it still continues to count.
I can send you the file if you have time to check it.

Again thanks for your time and patience.

Best regards

 

[Fluff]

Are you entering dates in those cells?