Forum Discussion
Complex IF formula
I am using Excel 2013 and trying to create an IF forumula:
I have a drop down list of 32 items in Cell F9. If they selection one of the first 16 I want to multiply Cell M9 by 1. If they select on...
Given that your drop-down list source is in O9:O41 (which is 33 cells not 32), then you can use the MATCH function to return the position of your F9 selection within the source list. If the position ios less than 17, then return whatever is in M9, otherwise return M9*L9.
=IF(MATCH(F9,$O$9:$O$41,0)<17,M9,M9*L9)
The 0 in the third argument of the MATCH function specifies an "exact match" which is OK because F9 must be selected from the list in $O$9:$O$41.