I'm trying to pull some data from cells in another sheet but ignore some of it. I'm using this but its not working.
Formula:=IF('Import data'!BQ2="location",if('Import data'!BQ2="average",if('import data"!BQ2="combination")),"",'Import data'!BQ2)
If i just have one IF it works fine but nested is not working.
Also this formula simply returns a blank cell. Is there a way to have it skip the cell and not return anything?
Bookmarks