Thread: Complex IF function is needed for the following, however gives !#VALUE

Need Help Plox!
In our assemesent task we need to design an excel soloution that creates an invoice for an home insurance agency. Part of the invoice is a section where you need to add a fee based on the house's age. Provided was a table that shows all the prices for each home age;

<1 640
1-10 700
10 - 50 850
50-100 1040

i kept this fee structure in a seperate worksheet named "FEE STRUCTURES", and the user enters data such as "6" in C2 and "months" in C3.

I need help on generating a formula that can put the values (that corresponds to the age of the home) from the table in the FEE STRUCTURES worksheet into the INVOICE worksheet

any help would be appreciated thankyou

Welcome to the forum.

Pleasetake a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

Hi,
looks better indeed.

Do you need a Mac solution or a Windows one?
Could you please provide a sheet with a small sample of your data ? This way a solution can be provided that takes the formatting of your input data into account