IF help

[markster]

Hi I'm stuck with an IF formula. I want to say if F5 = London or Paris then do this calculation. The calculation bit is fine it's just the if F5 is London or Paris. I've tried:

IF(OR(F5="London","Paris",SUM(W6:AA6)*K6/12*5%,0))

It doesn't work - can anyone help.
Cheers
Mark

 

[Andrew Poulsom]

Try:

=IF(OR(F5="London",F5="Paris"),SUM(W6:AA6)*K6/12*5%,0)

 

[patrickmuldoon99]

Hi

Try:

=IF(OR(F5="London",F5="Paris"),(SUM(W6:AA6)*K6/12*5%),0)

HTH

Patrick