application that requires multiple statements

Hi there I am looking for help in excel with multiple variables and I have hit a wall for the last 2 weeks.

What I am trying to do;
I want to have cell C8 in Worksheet1 to equal cells A25-A29 in Worksheet3 and also when cell F33 in Worksheet 1equal the Cells A35-A37 in worksheet3 a calculation is done based on the info in cell D18 in worksheet 1 and if it returns a limit under a set value the set value is returned…...

Example;

When cell C8 in worksheet 1 = A25-A29 in worksheet 3, and Cell F33 in worksheet 1 = A35 in worksheet 3, I want it to do an equation where it takes the amount from cell D18 in worksheet 1 and multiples it by 2 then divides it by 1000, but if the answer is less then 550 I want it to return 550.

When cell C8 in worksheet 1 = A25-A29 in worksheet 3, and Cell F33 in worksheet 1 = A36 in worksheet 3 I want it to do an equation where it takes the amount from cell D18 in worksheet 1 and multiples it by 2.42 then divides it by 1000, but if the answer is less then 600 I want it to return 600. **** Only exception in this one is when C8 in worksheet 1 = A29, the calculation of D18 is still 2.00 not 2.42)

When cell C8 in worksheet 1 = A25-A29 in worksheet 3, and Cell F33 in worksheet 1 = A37 in worksheet 3 I want it to do an equation where it takes the amount from cell D18 in worksheet 1 and multiples it by 2.70 then divides it by 1000, but if the answer is less then 650 I want it to return 650. **** Only exception in this one is when C8 in worksheet 1 = A29, the calculation of D18 is still 2.00 not 2.42)


I have the spread sheet done if you need me to post it please PM me and I will send it via email.


Thanks so much

Chris

Welcome to the forum.

Maybe this will get you started: for the first one, try

=IF( AND( COUNTIF( Sheet3!A25:A29, Sheet1!C8) = ROWS(Sheet3!A25:A29), Sheet1!F33=Sheet3!A35), MAX(550, Sheet1!D18/500) )

1st, where is the equation for cell D18 *2/1000?

2*d18/ 1000 is the same as d18/500

2nd for some reason the ROWS command is causing an error when I remove it seems to work, but again confused where the equation of D18*2/1000 is.

The ROWS function counts the number of rows;

COUNTIF( Sheet3!A25:A29, Sheet1!C8) = ROWS(Sheet3!A25:A29)

... tests if all five cells are the same as C8.