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
|