Max, Min, Round up and Plus through vba

Hi,

We are doing some manual calculation but now we have large data around 800 and want help to do it with vba or code

We are putting the Text Max in N2 and formula O2:Q2 (All formula are different)
and after that We are putting the Text Min in N3 and formula O3:Q3 (All formula are different)

All the above work we are doing in N8, N14 and all other.

we have attached the sheet for your reference.

kindly check and advice pls.

Done, all the things as u have mentioned

when we have run the macro, find the error

error is:

Compile error:

Variable not defined

find the solution,

HTML Code: 

that would work and expanding for the other formula would give you the solution

yes, its working, we have expand the formula as per our requirement.

Hi mehmetcik,

we have again checked with the formula you have provided, its working but last time its not working we don't know why

And with your formula, we have also learn many things