Thread: Priority Charge
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Priority Charge

You could try this:

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

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

Hope this helps.

Pete

Michell Major wrote:
=IF(L3="Hackney",25,IF(L3="Lewisham",30,IF(L3="Pin nacle",26)))

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