I have a spreadsheet that I need help with. Depending on the cost types, I
want Excel to go look at the column with the cost types in and return the
appropriate formula to the default column and then to to the next cell and do
the same, repeat to the end.

Below is a list of the cost types and corresponding formulas.

=IF(AND(K" & RowCount & "=0,N " & RowCount & "=0),0,IF(M " & RowCount & "<(R
" & RowCount & "*0.1),MAX(K " & RowCount & ", N " & RowCount & ", K " &
RowCount & "*AD " & RowCount & "), IF(V " & RowCount & "<U " & RowCount & ",
AA " & RowCount & " *AH" & RowCount & ",MAX(K " & RowCount & ",N " & RowCount
& ",AA " & RowCount & "*AH " & RowCount & "))))

for these Cost Types:
5515
5931
5932
5933
5934
5941
5943
5950
=IF(V " & RowCount & "<U " & RowCount & ",AA " & RowCount & " * AH " &
RowCount & ", MAX(K " & RowCount & ", N " & RowCount & ", AA " & RowCount &
"*AH " & RowCount & "))
Cost Types:5110
5119
5310
5317
5319
5320
5329
5511
5531

=MAX(K " & RowCount & ", N " & RowCount & ")
Cost Types:5117
5130
5327
5330
5521
5610
5620
5690
5830
5910
5980


Thanks for any help you can give me.

Laurie