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]

Try
=IF(OR(U4>AA3,V4>AA3,W4>AA3,Y4>AA3),0,IF(D4>0,AA3-X4,0))

 

[YOUNAN]

This is what i get when inserting the formla. see the file in link below.

https://wetransfer.com/downloads/65...7bc5e760843292cc23bcffc720190327152003/a412e3


Best regards

 

[Fluff]

You may need to swap the commas to whatever your region requires

 

[YOUNAN]

Thanks for your time , i am sorry to say i have no idea on how to swap the commas or where to place, i wonder if anyone else in this forum could help me.

Best regards.

 

[Fluff]

Just change all the commas in the formula I supplied to semi colons.

 

[YOUNAN]

I tested your last formula on 2 pc's , in the first one it didnt work until i changed comma with semi colons, on the second pc it worked with commas, i dont know why, is there an explanation for this ?
other wise the formula works and thank you very very much for your help.

 

[YOUNAN]

somthing strange happened, the formula didnt work on a pc without changing all comma's to semi colons, on another pc it worked directly without changing anything, is there an explanation for this ?
Other wise the formula works and thank you very very much for your help.

Best regards

 

[Special-K99]

You need to check the windows locale on each machine to see what's been set up as a separator

In Microsoft Windows, click the Start button, and then click Control Panel.
Open the dialog box for changing Regional and Language settings.
Type a new separator in the List separator box.
Click OK twice.