Forum Discussion
Fatih_Polat
Feb 07, 2020Copper Contributor
Excel IF-formula
Hi all, I'm looking for the easiest formula for the IF-function. This is what I'm exactly looking for: If C2 = V-838-NN then N2 has to be € 70,83. So each licence plate/vehicle has ...
- Feb 07, 2020
You want a more dynamic solution than just with IF. The attached workbook has a simple example how you combine a table containing plates and cost with cell that displays the cost (using VLOOKUP) for a selected plate (using Data Validation).
Riny_van_Eekelen
Feb 07, 2020Platinum Contributor
You want a more dynamic solution than just with IF. The attached workbook has a simple example how you combine a table containing plates and cost with cell that displays the cost (using VLOOKUP) for a selected plate (using Data Validation).
- Fatih_PolatFeb 07, 2020Copper ContributorThanks for your help ! This is what I'm looking for.
Dankjewel !- Riny_van_EekelenFeb 07, 2020Platinum Contributor
Fatih_Polat Graag gedaan!