Hi,
I believe this would be categorized as a "nested if" question.

I have to calculate different pricing based on weight categories.
So- in English, it would be:
If cell a1 is greater than 1000 but less than 1999 then multiply a1 times
c4, if A1 is greater is greater than 1999 but less than 2999 then multiply
A1 times C5, etc

Can someone provide an example of that syntax??

Thanks so much.