Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with this macro please
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to copy and paste values (columns)I have a macro file built | Excel Programming | |||
AutoRun Macro with a delay to give user the choice to cancel the macro | Excel Programming | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |