Need help with VBA code - "If untill" and basic VBA

Hey

I need some help with a VBA code. I've been trying to make some excel work without VBA, but i came to the conclusion that it isnt possible the way i want it to work withouit VBA code



I got an excel sheet with 54000 Rows of data. - Raindata

What i need is as following


Column T is where i want the data - "Volume of the water in the area"

what i need each row in T a calculation needs to be made
fx. in T6 = R6 / 1000 + T5 - But if T6 > 371 it needs to go down with the value in "H2" until T =<0.
as in T6 is 27 - T7 is 50 - T8 is 350 T9 is 373 - now it has to drop until T0<=0.

The parameters is as following.
T = R / 1000 + T-1 (T on row above) if T > 371 then this should be minus H2 until T<= 0. If T > 990 it has to go down with 2*"H2" until T=< 619 where it should only go down with "H2"


I have no idea if this rambling is understandable? i just really need some help or pointers. i've been trying with google but to no avail so far.

Dear HV.Excel

kindly attached with excel sample data File. so we will able to help you.

Dear HV.Excel,


In cell T5 assuming row 4 starts the calculation, enter this initial formula:

Formula:

Please Login or Register  to view this content.

In cell T6, you can use a more complex IF formula to handle your conditions.

Formula:

Please Login or Register  to view this content.

This formula checks if T6 exceeds 990, in which case it subtracts 2 * H2. If T6 is greater than 371, it subtracts H2. Otherwise, it just adds R7 / 1000 + T6 as usual.

i attached the sample File

Dear HV.Excel

Starting in T5
Set an initial value:

In T5: Enter your starting volume, e.g., 0.
Formula for T6 enter the following formula:

Formula:

Please Login or Register  to view this content.

In T7, enter the following formula:

Formula:

Please Login or Register  to view this content.

I might have been unprecise. let me try to make it more precise

*
When T < 371 then T = R/1000 + T-1 (the cell above)

When T >= 371 And T<= 990 then T = R/1000 - H2 + T-1(the cell above) untill T <= 0

When T > 990 then T = R/1000 - 2*H2 + T-1(the cell above) untill T <= 619
*


does this make more sense?

@sudbhavani

Hmm this is closer to correct, but the value i subtract (H2) is getting smaller and smaller in your fomula

Dear HV.Excel,

Thank you for pointing that out! I understand now that you want a constant subtraction of H2
2xH2 if above 990) until the conditions are met, rather than reducing the subtraction gradually
Set an initial value in T5. 0
Change the Formula for T6

Formula:

Please Login or Register  to view this content.

Once you enter this formula in T6, you can drag it down for as many rows as you need. This approach ensures that each cell in column T adjusts based on the thresholds consistently, and once a threshold is hit, the subtraction of H2 or 2×𝐻2 continues until the target values are reached.

Let me know if this aligns with your needs or if any further adjustments are necessary!

Thanks for the reply

This meets the first criteria that is needed, but sadly i doesnt help with the big problem i have.
Once the value of T hits 371, it needs to subtract H2, untill T <= 0. Then it has to stop the subtraction of H2 until T hits 371 again.
- this is where im unsure if it's possible to do without WhatIF analysis or VBA coding? (since there is no "Until" formula i can use?

Administrative Note re. Forum Guideline #2:

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter and rarely necessary.

If you are responding out of sequence, it is usually enough just to mention the helper's user name (e.g @AliGW).

If you do need to quote, limit the quoted section just to the section to which you wish to draw your helper's attention or a direct question to which you wish to respond.

For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.

The parameters is as following.
T = R / 1000 + T-1 (T on row above) if T > 371 then this should be minus H2 until T<= 0. If T > 990 it has to go down with 2*"H2" until T=< 619 where it should only go down with "H2"

Perhaps...taking above parameters into consideration...

Please Login or Register  to view this content.