How to increment cell value with IF condtion?

[zakmuh]

Hi everyone!

I'd be greateful if anyone can help me on this complicated query. Maybe easy peasy for you

I'm a structural design engineer and I want to develop my own spreadsheet to calculate required area (mm^2) of reinforcement bars in concrete to avoid concrete cracking due to temperature rise in summer. Available input are min area of reinfor (cell A3), crack width limit (A1) and calculated crack with (A2). For example.....

A1= Crack width limit 0.2mm. A2= Calculated crack 0.28mm (which is higher than the limit 0.2mm; therefore min area of reinfor A3= 1450mm^2 is insufficient to stop concrete from cracking). Now......to stop cracking, I want cell B1 to take 1450 from A3 and keep increasing it until the condiotn A1>=A2 is met and I want cell B1 to display that increament( lets say 1780mm^2). I hope you do get what exaclty I want to do in excel

I don't have much experience in Excel so I don't know anything about Macro/VBA coding etc. Can we do a simple thing like this B1=IF(A1>=A2,A3,somthing here to keep adding a value to A3??) OR do we have to give pragamming code???

If it has to be Macro/VBA, could you please give me the complete coding with an instruction where to write it.

Cheers

NB: There are several calculations done with manual inputs within the sheet to derive the A2 (0.28mm) value

 

[zakmuh]

Well wot I mean by working is...I could see values in cells A2 ( calculated crack with) and B1 (required rebar area) are changing and then, as soon as they change the sheet freezes...

Thanks Shrikant

 

[Shrikant]

I have tries this code to ensure it's error free.


https://www.dropbox.com/s/aabmi7rejn5h8gi/Zakmuh Retaining Wall - Copy.xls

If the loop continues (File does not respond) after a long time then press Ctrl+Break to end the loop and escape the code.
I hope you will not have to do it more often.

please give your feedback.

 

[Shrikant]

I have also added a button called "Run" at the top of your sheet "Crack Control"

 

[zakmuh]

YOU ARE A STAR

It works perfectly Shrikant! Thank you so much for solving my query mate.

Just for my info Im asking...VBA and Macro, are they both same? I think in Macro you dont have to Run the programme? Please correct me if Im wrong

Thanks again

 

[Shrikant]

VBA is visual basic for application. It is a programming language.

Macro is a program written in VBA to "Tell" the application what to do. In short it is a written instructions to the application to perform tasks in given manner.

 

[zakmuh]

Oh okay. The issue is SOLVED.

Thanks!