I receive a monthly spreadsheet (per project number) with approximately 30
columns. The columns are always in the same location, but there may be more
or less rows each month depending on the project.

I have inserted a column that needs some help coding.

For example, Column F is where the cost types are located. Column U is the
column that I've inserted that requires the coding. Depending on the cost
type in column F, determines the formula that is used in column U.

Example:

Cost type 5830 (which appears in multiple rows), requires me to use the
formula =max(G70,H70) (70 being the row number that would change with each
row). Another example is cost type 5320 (which again appears in multiple
rows), which would need the formula =if(M70<L70,N70*J70,
max(G70,H70,N70*J70)).

Is there VBA coding that would loop through each of the cells in the default
U column, look into column F and determine which formula to use? And then
continue to the next cell in column U and do the same thing?

I am fairly new at Excel coding. Help please ?