Forum Discussion
Need help with multiple IF formulas in a single cell
Hi, All! I'm working on a sheet where I have a cell that I need multiple IF formulas in and I don't believe I'm doing it right and I'm not sure if it's possible. Here's what I'm working with: O...
just try with IFS FORMULA
=IFS($A2='Quarterly Goals'!$A$2,'Quarterly Goals'!C$2,$A2='Quarterly Goals'!$A$3,'Quarterly Goals'!C$3,$A2='Quarterly Goals'!$A$4,'Quarterly Goals'!C$4,$A2='Quarterly Goals'!$A$5,'Quarterly Goals'!C$5,$A2='Quarterly Goals'!$A$6,'Quarterly Goals'!C$6,$A2='Quarterly Goals'!$A$7,'Quarterly Goals'!C$7,$A2='Quarterly Goals'!$A$8,'Quarterly Goals'!C$8,$A2='Quarterly Goals'!$A$9,'Quarterly Goals'!C$9,$A2='Quarterly Goals'!$A$10,'Quarterly Goals'!C$10,,true,"")