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: ...
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?
