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

Copper Contributor

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:

 

DsmithOU_0-1713198714006.png

 

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. 

1 Reply

@DsmithOU 

 

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?