IF help

markster

Active Member
Joined
May 23, 2002
Messages
484
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
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Watch MrExcel Video

Forum statistics

Threads
1,113,849
Messages
5,544,645
Members
410,627
Latest member
georgealice
Top