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...
I advise you to depend on the source of that drop-down list in the logical test as shown in the below screenshot:
This is the formula:
=IF(F19<>"",IF(OR(F19=A1:A16),M19,L19*M19),"")
To enter it, press Ctrl+Shift+Enter because it's an array formula.
You are so Awesome!!! Thank you so much!!!