# 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; and D3=1100 and BN3={na} then multiply 25*1 or

A3=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; and D3=1200 and BN3={na} then multiply 25*1 or

A3=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; and D3=1100 and BO3={na} then multiply 25*1 or

A3=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; and D3=1200 and BO3={na} then multiply 25*1 or

A3=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; 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=&quot;ALBANY&quot; and D3=1500 and BO3={na} then multiply 25*1 or

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

Thanks

Rob

Taidot: Excel

Tietoa työnantajasta:
( 10 arvostelua ) Cabarita Beach, Australia

Projektin tunnus: #1737758

## Myönnetty käyttäjälle:

crispymasala

Hired by the Employer

\$30 AUD 7 päivässä
(7 Arvostelua)
3.3