Hi all.
I'm renting out construction tools and have my margin at different rates depending on the number of rental days.
This is what my days-margin cells look like:
<tbody>
</tbody>If I have A3 titled "Number of Days", B3 shows the number (i.e 5) and want C3 to show the appropriate margin, what fomula do I need for C3?
<tbody>
</tbody>
Thanks!!
I'm renting out construction tools and have my margin at different rates depending on the number of rental days.
This is what my days-margin cells look like:
D | E |
Days | Margin |
1 | 1.4 |
2 | 1.3 |
3-7 | 1.2 |
8-14 | 1.15 |
<tbody>
</tbody>
2 | A | B | C |
3 | Number of days | 5 | ? |
<tbody>
</tbody>
Thanks!!
Last edited: