Formula for calculation based on rang

Status
Not open for further replies.

Tripleseas

Board Regular
Joined
Jul 12, 2022
Messages
87
Office Version
  1. 2013
Platform
  1. Windows
Hello community

i'm working on worbook and i need to do some calculation like this :

depending on the price in the 3 differents rang ( Cell B3 to Cell D28 ) in comparisson the rang table , if that rang is detected i want the price in the base table to be multiplied by numbers of days in that month

I did some manual examples :
Cell D3 = 60 000 ---> it's in the rang 50 001 - 180 000 ----> result : 250 ( the price of the rang ) * 31 ( numbers of days of january )

i also seperated the rangs ! i want to the calculations of the months of rang 3 to be done based on column rang 3 and so on for the others.

hope i was clear and thank you for the help.


price formulas.xlsx
ABCDEFGHIJKLMNOP
1Rang Price
20-5 00020,83
35 001 -50 00083,33
450 001 -180 000250,00
5RANG 3Rang 1RANG 2
6Gare de péage Rang 1Rang 2 Rang 3JanvierFévrierMarsAvrilMaiJuinJuilletAoûtSeptembreOctobreNovembreDécembre
7X1120 00072 00060 0007750
8X280 00048 00040 000
9X340 00024 00020 000
10X4100 00060 00050 000
11X520 00012 00010 000
12X6100 00060 00050 000
13X710 0006 0005 000645,73
14X870 00042 00035 000
15X920 00012 00010 000
16X1030 00018 00015 000
17X115 0003 0002 500
18X125 0003 0002 500
19X135 0003 0002 500
20X145 0003 0002 500
21X15180 000108 00090 000
22X1610 0006 0005 000
23X175 0003 0002 500
24X185 0003 0002 500
25X1915 0009 0007 500
26X205 0003 0002 500
27X215 0003 0002 500
28X225 0003 0002 500
29X235 0003 0002 500
30X2450 00030 00025 000
31X2545 00027 00022 500
32X268 0004 8004 000
Feuil1
Cell Formulas
RangeFormula
B3B3=100/1.2
E7E7=250*31
E13E13=20.83*31
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Duplicate to: complicated calculation of price formula

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,213,563
Messages
6,114,332
Members
448,566
Latest member
Nickdozaj

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top