Đang Thực Hiện

Excel IF function

Hi Crispy

I need to create 2 Excel IF functions. It is hard for me to explain but here is an example and using the Excel file provided this will help explain what I need

Excel function 1

Start in cell CV3

=IF A3="ALBANY" and D3=1100 and BN3={F1 or F2 or F3 or F4 or F5 or F6 or F7or F8 or F9 or F10 or F11 or F12} then multiply JA3*1 or

A3="ALBANY" and D3=1100 and BN3={G1 or G2 or G3 or G4 or G5 or G6 or G7or G8 or G9 or G10 or G11 or G12} then multiply JB3*1 or

A3="ALBANY" and D3=1100 and BN3={M1 or M2 or M3 or M4 or M5 or M6 or M7or M8 or M9 or M10 or M11 or M12} then multiply JC3*1 or

A3="ALBANY" and D3=1100 and BN3={S1 or S2 or S3 or S4 or S5 or S6 or S7or S8 or S9 or S10 or S11 or S12} then multiply JD3*1 or

A3="ALBANY" and D3=1100 and BN3={na} then multiply 25*1 or

A3="ALBANY" and D3=1200 and BN3={F1 or F2 or F3 or F4 or F5 or F6 or F7or F8 or F9 or F10 or F11 or F12} then multiply JA4*1 or

A3="ALBANY" and D3=1200 and BN3={G1 or G2 or G3 or G4 or G5 or G6 or G7or G8 or G9 or G10 or G11 or G12} then multiply JB4*1 or

A3="ALBANY" and D3=1200 and BN3={M1 or M2 or M3 or M4 or M5 or M6 or M7or M8 or M9 or M10 or M11 or M12} then multiply JC4*1 or

A3="ALBANY" and D3=1200 and BN3={S1 or S2 or S3 or S4 or S5 or S6 or S7or S8 or S9 or S10 or S11 or S12} then multiply JD4*1 or

A3="ALBANY" and D3=1200 and BN3={na} then multiply 25*1 or

A3="ALBANY" and D3=1500 and BN3={F1 or F2 or F3 or F4 or F5 or F6 or F7or F8 or F9 or F10 or F11 or F12} then multiply JA5*1 or

A3="ALBANY" and D3=1500 and BN3={G1 or G2 or G3 or G4 or G5 or G6 or G7or G8 or G9 or G10 or G11 or G12} then multiply JB5*1 or

A3="ALBANY" and D3=1500 and BN3={M1 or M2 or M3 or M4 or M5 or M6 or M7or M8 or M9 or M10 or M11 or M12} then multiply JC5*1 or

A3="ALBANY" and D3=1500 and BN3={S1 or S2 or S3 or S4 or S5 or S6 or S7or S8 or S9 or S10 or S11 or S12} then multiply JD5*1 or

A3="ALBANY" and D3=1500 and BN3={na} then multiply 25*1 or

etc ...... the formulae would continue until Wyong 2100 ( see line A265 )

Excel function 2

Start in cell CW3

=IF A3="ALBANY" and D3=1100 and BO3={F1 or F2 or F3 or F4 or F5 or F6 or F7or F8 or F9 or F10 or F11 or F12} then multiply JE3*1 or

A3="ALBANY" and D3=1100 and BO3={O1 or O2 or O3 or O4 or O5 or O6 or O7or O8 or O9 or O10 or O11 or O12} then multiply JF3*1 or

A3="ALBANY" and D3=1100 and BO3={M1 or M2 or M3 or M4 or M5 or M6 or M7or M8 or M9 or M10 or M11 or M12} then multiply JG3*1 or

A3="ALBANY" and D3=1100 and BO3={B1 or B2 or B3 or B4 or B5 or B6 or B7or B8 or B9 or B10 or B11 or B12} then multiply JH3*1 or

A3="ALBANY" and D3=1100 and BO3={na} then multiply 25*1 or

A3="ALBANY" and D3=1200 and BO3={F1 or F2 or F3 or F4 or F5 or F6 or F7or F8 or F9 or F10 or F11 or F12} then multiply JE4*1 or

A3="ALBANY" and D3=1200 and BO3={O1 or O2 or O3 or O4 or O5 or O6 or O7or O8 or O9 or O10 or O11 or O12} then multiply JF4*1 or

A3="ALBANY" and D3=1200 and BO3={M1 or M2 or M3 or M4 or M5 or M6 or M7or M8 or M9 or M10 or M11 or M12} then multiply JG4*1 or

A3="ALBANY" and D3=1200 and BO3={B1 or B2 or B3 or B4 or B5 or B6 or B7or B8 or B9 or B10 or B11 or B12} then multiply JH4*1 or

A3="ALBANY" and D3=1200 and BO3={na} then multiply 25*1 or

A3="ALBANY" and D3=1500 and BO3={F1 or F2 or F3 or F4 or F5 or F6 or F7or F8 or F9 or F10 or F11 or F12} then multiply JE5*1 or

A3="ALBANY" and D3=1500 and BO3={O1 or O2 or O3 or O4 or O5 or O6 or O7or O8 or O9 or O10 or O11 or O12} then multiply JF5*1 or

A3="ALBANY" and D3=1500 and BO3={M1 or M2 or M3 or M4 or M5 or M6 or M7or M8 or M9 or M10 or M11 or M12} then multiply JG5*1 or

A3="ALBANY" and D3=1500 and BO3={B1 or B2 or B3 or B4 or B5 or B6 or B7or B8 or B9 or B10 or B11 or B12} then multiply JH5*1 or

A3="ALBANY" and D3=1500 and BO3={na} then multiply 25*1 or

etc ...... the formulae would continue until Wyong 2100 ( see line A265 )

Thanks

Rob

Kỹ năng: Excel

Xem thêm: o9, i need excel help, function - 1 to 1, need excel help, what if, s5, s4, Rob, M3, m1, g1, function, f2, f1, excel function, B3, b2, excel cell, 1500 excel, excel line, need excel, excel 1500, explain excel, s1, multiply

Về Bên Thuê:
( 10 nhận xét ) Cabarita Beach, Australia

Mã Dự Án: #1737758

Đã trao cho:

crispymasala

Hired by the Employer

$30 AUD trong 7 ngày
(7 Đánh Giá)
3.3