# Re: Multiple amounts for Multi Select Field

Solved
395 0
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

So Im pretty new to Airtable and not sure if I am going about this the right way and wonder if someone can point me in the right direction if not. Basically I am trying to use a multi select option to calculate the Extra costs involved in a job with solar installations which I have a field named Extras. So lets just say I have an option of installing on a tile roof which costs an extra 50 which I have added using the formulas below in a separate field called Extras Total.

IF(
FIND('Tile Roof', Extras),
50
) +
IF(
FIND('3 phase', Extras),
200
) +
IF(
FIND('Solar Hot Water Removal', Extras),
800
) +
IF(
FIND('Optimiser', Extras),
100
) +
IF(
FIND('Panel Removal', Extras),
20
)

Where I am having trouble is with panel removal and optimisers there may be more than 1 panel or optimiser so is there a way that I can add multiple amounts to these particular options. My only thought would be to add multi options for each one e.g 1 panel removal, 2 panel removal, 3 panel removal etc. But this way would make it messy and have so many options and also would make the above formula very long, is there any way to streamline this?
1 Solution

Accepted Solutions
18 - Pluto

Hmm, maybe use a new field called "# of Panels Removed" or something, and have the formula use that?

``````IF(
FIND('Tile Roof', Extras),
50
) +
IF(
FIND('Panel Removal', Extras),
{# of Panels Removed} * 20
)``````

2 Replies 2
18 - Pluto

Hmm, maybe use a new field called "# of Panels Removed" or something, and have the formula use that?

``````IF(
FIND('Tile Roof', Extras),
50
) +
IF(
FIND('Panel Removal', Extras),
{# of Panels Removed} * 20
)``````

5 - Automation Enthusiast

Yeah I think this is a good solution, thank you!