ExcelBanter - Priority Charge

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Priority Charge (https://www.excelbanter.com/excel-discussion-misc-queries/114900-priority-charge.html)

Michell Major

Priority Charge

=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

Roger Govier

Priority Charge

see response to your question 14 clients

--
Regards

Roger Govier

"Michell Major" wrote in
message ...
=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

Pete_UK

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

David Biddulph

Priority Charge

=IF(L3="Hackney",25,IF(L3="Lewisham",30,IF(L3="Pin nacle",26,"undefined")))+IF(J3="P",10,0)
--
David Biddulph

"Michell Major" wrote in message
...
=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

All times are GMT +1. The time now is 10:21 PM.