Priority Charge

M

Michell Major

=IF(L3="Hackney",25,IF(L3="Lewisham",30,IF(L3="Pinnacle",26)))

Sometimes we need to add $10 for a priority callout across the board.
Suggestions please on how ... IF(J3=P then add $10
 
P

Pete_UK

You could try this:

=IF(L3="Hackney",25+(J3="P")*10,IF(L3="Lewisham",30+(J3="P")*10,26+(J3="P")*10))

I've amended the formula in line with your other post.

Hope this helps.

Pete
 
D

David Biddulph

=IF(L3="Hackney",25,IF(L3="Lewisham",30,IF(L3="Pinnacle",26,"undefined")))+IF(J3="P",10,0)
 
Top