Forum Discussion
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.
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?
