Closed

Excel IF function

This project was awarded to crispymasala for $30 AUD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 AUD
Total Bids
1
Project Description

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online