markster
Well-known Member
- Joined
- May 23, 2002
- Messages
- 579
- Office Version
- 365
- Platform
- Windows
- MacOS
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
IF(OR(F5="London","Paris",SUM(W6:AA6)*K6/12*5%,0))
It doesn't work - can anyone help.
Cheers
Mark