Excel IF function

Budget $30 AUD
Bids 1
Average Bid $30

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

Post a Project Like This

This project was awarded to

crispymasala

Crispy and team did some fantastic work with this task, they provided recommendations where they thought improvements could be made. Project: Access to MySQL database was converted with no issues, and the front end was developed in Java as recommended by the team. They did not give up on the project and were very helpful in ironing out the final details to ensure the application worked as I scoped. Future Work: I would have no hesitations in recommending for future work and I would strongly recommend this freelancer. Communication: They kept me informed of progress at every step and sought clarification where instructions were unclear. They gave me a skype demonstration. Email and skype IM were well utilised during this project.
About the Freelancer
crispymasala Profile Picture

Any Software Problem Challenge is accepted. PHP,Java Script,JQuery,Ajax,CSS Database : Oracle, SQL Server,MySQL,Access Joomla,WordPress,Drupal,Flynax Data Entry,Excel,Web Site Administration - Comprehensive Service Provided with focus on Customer Satisfaction.We take utmost care to meet customer demand.

Looking to make some money?

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

Bids on this Project

  • crispymasala Profile Picture

    crispymasala

    Bangalore,  India

    Any Software Problem Challenge is accepted. PHP,Java Script,JQuery,Ajax,CSS Database : Oracle, SQL Server,MySQL,Access Joomla,WordPress,Drupal,Flynax Data Entry,Excel,Web Site Administration - Comprehensive Service Provided with focus on Customer Satisfaction.We take utmost care to meet customer demand.

    PHP, Java, Javascript, and XML