| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Finance Charge | Excel Discussion (Misc queries) | |||
| Sorting according to priority help!! | Excel Discussion (Misc queries) | |||
| New Priority Column | Excel Discussion (Misc queries) | |||
| priority naming | Excel Worksheet Functions | |||
| Help needed with priority list | Excel Worksheet Functions | |||
Linear Mode
