Forum Discussion
IF AND
WishIWerentAN00b Many of the brackets should be removed. A working formula could look like this:
=AM3*(IFS(
AND(AJ3="BASELINE",AB3="mini"),$I$219,
AND(AJ3="BASELINE",AB3="micro"),$I$220,
AND(AJ3="BASELINE",AB3="mid-tier"),$I$221,
AND(AJ3="BASELINE",AB3="medium"),$I$222,
AND(AJ3="BASELINE",AB3="big"),$I$223,
AND(AJ3="BASELINE",AB3="mega"),$I$224,
AND(AJ3="TOP",AB3="mini"),$I$228,
AND(AJ3="TOP",AB3="micro"),$I$229,
AND(AJ3="TOP",AB3="mid-tier"),$I$230,
AND(AJ3="TOP",AB3="medium"),$I$231,
AND(AJ3="TOP",AB3="BIG"),$I$232,
AND(AJ3="TOP",AB3="mega"),$I$233
))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.
