Forum Discussion
IF AND
=AM3*(IFS(AND(AJ3="BASELINE";AB3="mini");Inf_Sales_Dashboard!$I$219);(AND(AJ3="BASELINE";AB3="micro");Inf_Sales_Dashboard!$I$220);(AND(AJ3="BASELINE";AB3="mid-tier");Inf_Sales_Dashboard!$I$221);(AND(...
Riny_van_Eekelen thanks so much!
This is the formula I used now:
=AM3*(IFS(AND(AJ3="BASELINE";AB3="mini");Inf_Sales_Dashboard!B219;(AJ3="BASELINE";AB3="micro");Inf_Sales_Dashboard!B220;AND(AJ3="BASELINE";AB3="mid-tier");Inf_Sales_Dashboard!B221;AND(AJ3="BASELINE";AB3="medium");Inf_Sales_Dashboard!B222;AND(AJ3="BASELINE";AB3="big");Inf_Sales_Dashboard!B223;AND(AJ3="BASELINE";AB3="mega");Inf_Sales_Dashboard!B224;AND(AJ3="top";AB3="mini");Inf_Sales_Dashboard!B228;AND(AJ3="top";AB3="micro");Inf_Sales_Dashboard!B229;AND(AJ3="top";AB3="mid-tier");Inf_Sales_Dashboard!B230;AND(AJ3="top";AB3="medium");Inf_Sales_Dashboard!B231;AND(AJ3="top";AB3="big");Inf_Sales_Dashboard!B232;AND(AJ3="top";AB3="mega");Inf_Sales_Dashboard!B233))
but it returns a parse error 😞
WishIWerentAN00b Can't really tell. The formula seems rather complicated for something rater simple. What's a "parse error"?
Can you share the file (OneDrive, Dropbox or the likes)?
By the way, I must apologize for the fact that I didn't mention that I removed all the sheet references and swapped the semi-colons for commas. I couldn't "see" a working formula on my system otherwise.