Trying to work on formula based on looking for month and then multiply by values in adjacent cell, currently using the following formula but it has too many arguments and cant be updated if new month is added.
tried sum product but couldn't generate a workable formula. therefore need help in nesting this formula or any other way to calculate.
=IF(B2=N$2,A2*P$2,IF(B2=N$3,A2*P$3,IF(B2=N$4,A2*P$4,IF(B2=N$5,A2*P$5,IF(B2=N$6,A2*P$6)))))
Bookmarks