# Is this the correct function to use for multiple data ranges?

Copper Contributor

# Is this the correct function to use for multiple data ranges?

I'm trying to take data from cells within a table and create a formula. I've tried the IF and IFS funcitons but cannot get multiple ranges to work. Here's what I'm trying to accomplish:

What I'm trying to accomplish: I type xxx (number) in the cell next to "Target" and the cell that says #N/A gives me a projected dollar amount based on a <> data set. For Example, 3,500,000 to 7,500,000 visits will provide a projected dollar amount of \$8,500,000; 8,000,000 to 10,500,000 visits will provide a projected dollar amount of \$10,500,000, etc.

# Re: Is this the correct function to use for multiple data ranges?

You said, "What I'm trying to accomplish: I type xxx (number) in the cell next to "Target" and the cell that says #N/A gives me a projected dollar amount based on a <> data set."

Functions used in formulas are geographically based, in order to have an idea which functions to use for your formulas.

My question: What does your dataset look like?