how to fill cell m34-dh34 with certain condition?? (vba)

kiralukaslarson

New Member
Joined
May 26, 2015
Messages
7
note:
Time: Cell D6
Date Format Birthday: Month, Date, Year cell D3-f3
Age / Age: cell m 15 - dh15
Cell M34 - DH34: Place in its contents PINNACLE VALUE according to Time value
Pinnacle Value: the result of addition of D3-F3 cell , THERE IS of 4 Pinnacle value .


Iam looking for formula or vba macro to solved my problem. :confused::confused:I want to try to calculate the pinnacle value. there are 4 pinnacle values and the results are obtained in a way that is:
1. First Pinnacle value: Month + Date (Cell D3 + e3)
example: 2 + 9 = 11 (note if final result number 11, 22 is not reduced to 2, 4)
2. Second Pinnacle value: Date + Year (cell e3 + f3)
example 9 + 5 (1 + 9 + 9 + 4 = 5) = 5 (note if the final result of number 11.22 is not reduced to 2, 4)
3. Third Pinnacle value: Number of first Pinnacle + second pinnacle
(11) + 5 = 7 (note if the final result of number 11.22 is not reduced to 2, 4)
4. Pinnacle value to 4: month + year results (cell d3 + f3)
2 (11) + 5 = 7 (note if the final result of number 11.22 is not reduced to 2, 4)


I expect All Pinnacle Value to appear automatically in cell M34 - DH34 when Time is already found according to the conditions below:
A. if Time is 1 change of pinnacle value at age
1. ages 0 - 35
2: ages 36 - 44
3: ages 45 - 53
4: age 54 +
B. if Time 2 changes the value of pinnacle in age
1.USA 0 - 34
2: ages 35 - 43
3: ages 44 - 52
4: ages 53+
C. if Time is 3 change of pinnacle value at age
1.USA 0 - 33
2: ages 34 - 42


ages 43 - 51
age 52 +
D. if Time is 4 change of pinnacle value at age
1. 0 - 32
2: 33 - 41 years of age
3: ages 42 - 50
4: age 51 +
E. if Time is 5 change of pinnacle value at age
1. ages 0 - 31
2: ages 32 - 40
3: ages 41 - 49
4: age 50+
F. if Time 6 changes the pinnacle value in age


0 - 30
ages 31 - 39
3. age 40 - 48
4. 49 +


G. if Time 7 changes the pinnacle value in age
1. 0 - 29
2: ages 30 - 38
3: ages 39 - 47
4: 48 + age


H. If Time 8 changes the pinnacle value by age
1. 0 - 28
.2: age 29 - 37
.3: ages 38 - 46 to
4: age 47 +
I. If TIME 9 changes in age


0 - 27
28 - 36
age 37 - 45
age 46 +
What I'm asking:
1. How to get Pinnacle Value in cell M34 - DH4 filled automatically And change at certain age According to Time value specified? ?
because there is nine Time Value, And more than one Pinnacle Value (1st pinnacle, 2nd pinnacle,3rd pinnacle, 4thpinnacle).



here my example excel files if my question little bit complicated https://ufile.io/oayld
 
Last edited:

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,223,237
Messages
6,170,928
Members
452,366
Latest member
TePunaBloke

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